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 7 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.   A second question will be asked regarding if you want to keep the table on the target or create it anew.  By choosing this method Replicate will automatically load the data when you start up the MINE process and APPLY process.

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