Oracle – Data Pump

expdp "\/ as sysdba\" SCHEMAS=xyz,abc ..... FLASHBACK_TIME=systimestamp

SQL> select current_scn from v$database;

expdp "\/ as sysdba\" SCHEMAS=xyz,abc ..... FLASHBACK_SCN=nnnnnnnnnn
where nnnnnnnnnn = current_scn from the previous query

Leave a Reply

Your email address will not be published. Required fields are marked *