Example:-
Specific time FLASHBACK_TIME="TO_TIMESTAMP('17-08-2018 12:22:00', 'DD-MM-YYYY HH24:MI:SS')" Current time FLASHBACK_TIME="TO_TIMESTAMP(TO_CHAR(SYSDATE,'YYYY-MM-DD HH24:MI:SS'),'YYYY-MM-DD HH24:MI:SS')" OR Flashback_time=systimestamp Daily time at 03PM Flashback_time="to_timestamp(to_char(trunc(sysdate)+15/24,'YYYY-MM-DD'),'YYYY-MM-DD')"
FLASHBACK_TIME=SYSTIMESTAMP:
FLASHBACK_TIME parameter finds the SCN that most closely matches the specified time. This SCN is used to enable the Flashback utility.
This parameter initiate the current system time.
[oracle@prod101:~ source] expdp system/manager directory=DATA_PUMP_DIR dumpfile=sample1.dmp logfile=sample1.log schemas=sample flashback_time=systimestamp
Export: Release 18.0.0.0.0 - Production on Fri Aug 17 12:19:28 2018
Version 18.3.0.0.0
Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": system/******** directory=DATA_PUMP_DIR dumpfile=sample1.dmp logfile=sample1.log schemas=sample flashback_time=systimestamp
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/STATISTICS/MARKER
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
. . exported "SAMPLE"."DEMO" 20.71 KB 38 rows
. . exported "SAMPLE"."DEMO1" 872.4 KB 99901 rows
. . exported "SAMPLE"."DEMO2" 8.568 MB 999901 rows
Master table "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is:
/u01/app/oracle/admin/source/dpdump/sample1.dmp
Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully completed at Fri Aug 17 12:21:25 2018 elapsed 0 00:01:56
Catch Me On:- Hariprasath Rajaram
Telegram:https://t.me/joinchat/I_f4DhGF_Zifr9YZvvMkRg
LinkedIn:https://www.linkedin.com/in/hari-prasath-aa65bb19/
Facebook:https://www.facebook.com/HariPrasathdba
FB Group:https://www.facebook.com/groups/894402327369506/
FB Page: https://www.facebook.com/dbahariprasath/?
Twitter: https://twitter.com/hariprasathdba
