<<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 parameterExpdp FLASHBACK_SCN
Syntax and DescriptionFLASHBACK_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 DescriptionFLASHBACK_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
Comments
Post a Comment