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: