One may want to know if copy can be used starting with a certain SCN #.
General information.
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.
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.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy