Adding new object from a given SCN

When using AS OF <scn> clause of PREPARE TABLE command to include tables in the on-going replication from pre-specified SCN one has to consider several things beforehand.

  1. make sure that the current SCN of replication (where MINE and APPLY is right now) is not greater than the SCN in PREPARE AS OF <scn> command, e.g.:
    SCN   ---|-------|--------------|---------------------|-----------
    100 150 200 300
    APPLY MINE PREPARE AS OF Source DB
  2. make sure that the table has supplemental logging enabled as of SCN used in PREPARE AS OF <scn> command. If supplemental logging is not enabled Replicate will have to use current SCN instead, e.g.:

    dbvrep> prepare as of 2225767872 table TEST1.FORALL_TEST
    Prepare enabled supplemental logging, waiting for SCN advance enough to prevent ORA-01466 during consistent export....Waited 2 seconds until scn_to_timestamp changed.
    We've just added supplemental logging to the table and thus we must use a current SCN and can't use the required one of 2225767872.
    Connecting to running apply [TEST1.FORALL_TEST]: [Apply table removed (0 metadata record(s)). Apply table added (1 metadata record(s)).]
    Connecting to running mine [TEST1.FORALL_TEST]: [Table prepared (1 internal records).]
    Table TEST1.FORALL_TEST instantiated at SCN 2225768428