Versions Compared

Version Old Version 10 New Version 11
Changes made by

KrupeshD (Deactivated)

KrupeshD (Deactivated)

Saved on

Key

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

Adding new tables

...

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:

 

Section
Column
width5%

 

Columnwidth95%

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

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

...