In today’s post, we will cover How to Use Flashback during Export.
|
1 2 3 4 |
FLASHBACK_TIME expdp "'/ as sysdba'" directory=expimp_dump tables=webtelmwcore.account dumpfile=rep_test%u.dmp logfile=rep_mwrep08.log parallel=16 cluster=n FLASHBACK_TIME= \"TO_TIMESTAMP\(\'09/02/2016 16:00:00\',\'DD/MM/YYYY HH24:MI:SS\'\)\" exclude=trigger,grants,policy,rls_policy,ref_constraint,synonym,job,sequence,constraint |
|
1 2 3 4 5 6 7 |
FLASHBACK_SCN expdp "'/ as sysdba'" directory=expimp_dump tables=webtelreporting_qsdp.ejb__timer__tbl,webtelreporting_qsdp.aveaedr19agu,webtelreporting_qsdp.aveaedr14agu,webtelreporting_qsdp.counter_cache_qsdp,webtelreportin g_qsdp.session_data_record_qsdp,webtelreporting_qsdp.counter_qsdp,webtelreporting_qsdp.counter_type_qsdp,webtelreporting_qsdp.record_type_desc_qsdp,webtelreporting_ qsdp.event_data_record_qsdp,webtelreporting_qsdp.counter_history_qsdp dumpfile=rep_mwrep08%u.dmp logfile=rep_mwrep08.log parallel=16 cluster=n flashback_scn= 12482481618338 exclude=trigger,grants,policy,rls_policy,ref_constraint,synonym,job,sequence,constraint |
This value is found as follows;
|
1 2 3 4 5 |
SQL> select to_char (current_scn) from v$database; TO_CHAR(CURRENT_SCN) ---------------------------------------- 12491359042193 |
