Notifications

28 views

Overview


This knowledge base article will explain the expected results of data in a table depending on the the settings used in the Data Preservers and Exclude Tables when performing a clone.

Clone results when using data preservers and table exclusions


In these six scenarios below, we will be using a table named sys_temp:

__________________________________________________________________________________________________________

Exclude Table: No
Data Preserver: No

RESULTS:
All records and record count in sys_temp table on target will match the sys_temp table on source.

__________________________________________________________________________________________________________

Exclude Table: No

Data Preserver (no Conditions): Yes

RESULTS:
All records in sys_temp table on target clone are preserved.
Records in sys_temp table on source, which do not exist in sys_temp table on target (based on sys_id), are copied to sys_temp table on target.

__________________________________________________________________________________________________________

Exclude Table: No

Data Preserver (with Conditions): Yes

RESULTS:
Records in sys_temp table on target clone, picked up by Data Preserver, are preserved.
Records in sys_temp table from source, which do not exist in sys_temp table on target (based on sys_id), are copied to sys_temp table on target.
Records that exists in sys_temp table on target which are not picked up by the Data Preserver, are deleted if they do not exist on source (based on sys_id, or updated if they do exist on source.

__________________________________________________________________________________________________________

Exclude Table: Yes
Data Preserver (no Conditions): Yes

RESULTS:
All records in sys_temp table on target clone instance, are preserved. No records are copied over from the sys_temp table on the source.

__________________________________________________________________________________________________________

Exclude Table: Yes
Data Preserver (with Conditions): Yes

RESULTS:
Records in sys_temp table on target clone, picked up by Data Preserver, are preserved. No records are copied over from the sys_temp table on the source.

__________________________________________________________________________________________________________

Exclude Table: Yes
Data Preserver: No

RESULTS:
All records are deleted from the sys_temp table on target clone instance. It will be a table containing no records.
 

Additional Information


Related knowledge base articles on cloning, excluding a table, and data preservers:

System clone

Exclude a table from cloning

Data preservation on cloning target instances

Article Information

Last Updated:2018-11-08 14:35:12
Published:2018-11-08