Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
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 |
