How to add tables to existing Extract/Pump and Replicator
Step 1:
Stop all Extract, Pump and Replicators
Step 2:
Add the new tables to extract param file
Example : edit params EXT1
Step 3:
Login with user id alias and add schema trandata / table transdata
Dblogin useridalias GGADMIN
Example:
add schematrandata <schema name>, allcols
for table:
add trandata <schema_name>.<table_name>
step 4:
start the extract and pump process
step 5:
Perform the initial load by taking exp
backup using flashback scn
Select current_scn from v$database;
Expdp parfile
userid='/ as sysdba'
directory=EXPORT_GG
dumpfile=<file_name>.dmp
logfile=<log_name>.log
tables=<’SCHEMA.TABLE_NAME’
flashback_scn=<current_scn from
v$database
step 6:
Move the dumpfile to target server
Scp <dump file name> <target
server name>:<location>
Step 7:
Import the tables in target server
userid="/ as sysdba"
directory=EXPORT_GG
dumpfile=<dump file>.dmp
logfile=<log file name>.log
remap_schema=<schema name>:<target
schema name>
remap_tablespace=<tablespace_name>:<target
tablespace_name>
EXCLUDE=GRANT
EXCLUDE=REF_CONSTRAINT
EXCLUDE=CONSTRAINT
Step 8:
Edit the param file for replicator
Add like below for all tables.
MAP <source schema.tablename>, TARGET
<target schema.table name>, FILTER ( @GETENV ("TRANSACTION",
"CSN") > <scn captured during export>);
Step 9:
Start the replicator and monitor the
sync for some time
Step 10:
Remove the additional lines from
replicat param file and keep the existing format as below
Stop replicat
Edit param as below
Remove (MAP <source
schema.tablename>, TARGET <target schema.table name>, FILTER ( @GETENV
("TRANSACTION", "CSN") > <scn captured during
export>);
Keep (MAP USBK_SMS.*,TARGET GC2FS.*;)
Start the replicat
Comments
Post a Comment