Versions Compared

Version Old Version 11 New Version 12
Changes made by

KrupeshD (Deactivated)

KrupeshD (Deactivated)

Saved on

Key

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

Adding new tables

...

CCC

 

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

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

Therefore, use following 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:

Panel
bgColor

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

...