How to Take Consistent Database Export Using expdp

<<Back to Oracle DATAPUMP Main Page

Taking Consistent Database Export Using expdp

To perform consistent database export using expdp you can use either FLASHBACK_SCN or FLASHBACK_TIME parameter

Expdp FLASHBACK_SCN

Syntax and Description
FLASHBACK_SCN=scn_value

$ cat exp_full_pdb01.par
DIRECTORY=DUMP
DUMPFILE=EXP_PDB01_FULL%U.DMP
LOGFILE=EXP_PDB01_FULL.LOG
FULL=Y
FLASHBACK_SCN=4170479
You can find the current_scn from v$database view.

Expdp FLASHBACK_TIME

Syntax and Description
FLASHBACK_TIME="TO_TIMESTAMP(time-value)"

$ cat exp_full_pdb01.par
DIRECTORY=DUMP
DUMPFILE=EXP_PDB01_FULL%U.DMP
LOGFILE=EXP_PDB01_FULL.LOG
FULL=Y
REUSE_DUMPFILES=Y
FLASHBACK_TIME="TO_TIMESTAMP('23-10-2018 14:40:00', 'DD-MM-YYYY HH24:MI:SS')"

$ cat exp_full_pdb01.par
DIRECTORY=DUMP
DUMPFILE=EXP_PDB01_FULL%U.DMP
LOGFILE=EXP_PDB01_FULL.LOG
FULL=Y
REUSE_DUMPFILES=Y
FLASHBACK_TIME=SYSTIMESTAMP