Get the last system change number:
SELECT to_char(DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER,'9999999999999999999') from dual;
Then, datapump export using flashback_scn option:
expdp userid/password DIRECTORY=DATA_PUMP_DIR schemas=userid FLASHBACK_SCN=49552038 dumpfile=’abc.dmp’ logfile='abc.log'
Then import using normal parameters.
No comments:
Post a Comment