Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Next »

In section 2 of the Setup Wizard there is a question about what data instantiation script to create.  One of the choices available is called 'load'.  The option for load will not create a script.  By choosing this method Replicate will automatically load the data.  A second question will be asked regarding if you want to keep the table on the target or create it anew.

Example

 

Lock and copy the data initially one-by-one or at a single SCN?
one-by-one : Lock tables one by one and capture SCN
single-scn : One SCN for all tables
ddl-only   : Only DDL script for target objects
resetlogs  : Use SCN from last resetlogs operation (standby activation, rman incomplete recovery)   
(one-by-one/single-scn/ddl-only/resetlogs) [single-scn] 
What data instantiation script to create?
dp_networklink : Data Pump with network link. No export datafile is created (APPLY.sh)
dp_exp         : Data Pump with export datafile. Creates an export datafile (APPLY.sh)
exp            : Pre-datapump exp/imp with export datafile (APPLY.sh)
ddl_file       : DDL file created (APPLY.sql)
ddl_run        : DDL is automatically executed on target
load           : All replicated data is created and loaded automatically 
none           (dp_networklink/dp_exp/exp/ddl_file/ddl_run/load/none) [dp_networklink] load
Do you want to (re-)create the tables on target or keep them (they are already  created)? (create/keep) [keep] create   

 

 

  • No labels