Old export had CONSISTENT=Y, but Data Dump does not. Instead, you use the following syntax:
nice -n 19 expdp system schemas=scott directory=TEST_DIR dumpfile=scott.dmp logfile=scott.log job_name=scott_job flashback_time=\"TO_TIMESTAMP\(sysdate, \'DD-MM-YYYY HH24:MI:SS\'\)\"
No comments:
Post a Comment