Consistent export using datapump

In older export method we can specify consistent=y parameter in export commands or in parameter file for export.

In datapump we can achieve the consistent export using flashback_time parameter as below

expdp system/password@TEST directory=TEST_DIR DUMPFILE=TEST_expfull.dmp full=y LOGFILE=expfull.log FLASHBACK_TIME=\"TO_TIMESTAMP\(to_char\(sysdate,\'DD-MM-YYYY HH24:MI:SS\'\),\'DD-MM-YYYY HH24:MI:SS\'\)\"

Remember to create the directory before executing the expdp command.