Versions Compared

Version Old Version 20 New Version 21
Changes made by

Arjen Visser

KrupeshD (Deactivated)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Adding new tables

...

Info

The PREPARE commands add supplemental logging to the table if it was not there yet. This can sometimes result in the ORA-01466 error while performing step 3.

If this happens, we recommend using the internal commands to prepare a new table. In following example, scott.emp table is prepared. It first adds the supplemental logging, then waits for the SCN to advance then it does the actual PREPARE: 

dbvrep>ENGINE SUPPLEMENTAL LOGGING TABLE SCOTT.EMP ENABLE PRIMARY KEY
dbvrep>ENGINE WAIT_SCN_FLIP
dbvrep>PREPARE TABLE SCOTT.EMP

Note that the table needs to exist on the target side before the apply process can be resumed. Using datapump in step 3 is a good choice, since the import creates the table automatically if it does not exist.

Note

impdp does not actually compare the SCNs, but timestamp converted using dbms_flashback to SCN and the last_ddl time in dba_objects.

Adding new schemas

To add a new schema to the replication run the following command.

...