Return
-
Title
Is it possible to use copy to export using a SCN as reference for starting point? -
Description
One may want to know if copy can be used starting with a certain SCN #.
-
Cause
General information.
-
Resolution
It is not possible to use copy with SCN. The Oracle Export does allow this option using the flashback_scn option but the copy does not have all the options that Oracle Export uses as it is not designed to substitute Oracle Export.
-
Additional Information
The following are the parameters in Oracle Export that are meant for SCN and are self-explanatory:
flashback_scn The system change number (SCN) that Oracle export uses to enable flashback.
flashback_time Oracle export will discover the SCN that is closest to the specified time. This SCN is used to enable flashback.