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 table...
One blog for all ORACLE DBA scripts & AWS Cloud commands, OCI commands etc