Young, Hemant
I've tested FLASHBACK_TIME using "/ as sysdba" and it is working ...
version 12.1.0.2
Marian
$ expdp \"/ as sysdba\" dumpfile=export_dir:testtab.dmp
logfile=export_dir:testtab.log tables=bednar.testab
FLASHBACK_TIME=\"TO_TIMESTAMP\(\'1206090020\',\'ddmmhh24miss\'\)\"
Export: Release 12.1.0.2.0 - Production on Mon Jun 12 09:01:41 2017
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights
reserved.
Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 -
64bit Production
Starting "SYS"."SYS_EXPORT_TABLE_01": "/******** AS SYSDBA"
dumpfile=export_dir:testtab.dmp logfile=export_dir:testtab.log
tables=bednar.testab FLASHBACK_TIME="TO_TIMESTAMP('1206090020',
'ddmmhh24miss')"
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 64 KB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
. . exported "BEDNAR"."TESTAB" 5.085 KB 3
rows
Master table "SYS"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_TABLE_01 is:
/oracle/export/pump_export/testtab.dmp
Job "SYS"."SYS_EXPORT_TABLE_01" successfully completed at Mon Jun 12
09:01:45 2017 elapsed 0 00:00:03
$ rm "/oracle/export/pump_export/testtab.dmp"
$ expdp \"/ as sysdba\" dumpfile=export_dir:testtab.dmp
logfile=export_dir:testtab.log tables=bednar.testab
Export: Release 12.1.0.2.0 - Production on Mon Jun 12 09:02:03 2017
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights
reserved.
Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 -
64bit Production
Starting "SYS"."SYS_EXPORT_TABLE_01": "/******** AS SYSDBA"
dumpfile=export_dir:testtab.dmp logfile=export_dir:testtab.log
tables=bednar.testab
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 64 KB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
. . exported "BEDNAR"."TESTAB" 5.093 KB 4
rows
Master table "SYS"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_TABLE_01 is:
/oracle/export/pump_export/testtab.dmp
Job "SYS"."SYS_EXPORT_TABLE_01" successfully completed at Mon Jun 12
09:02:05 2017 elapsed 0 00:00:01
$
From: "Yong Huang" <dmarc-noreply@xxxxxxxxxxxxx> (Redacted sender
"yong321" for DMARC)
To: Oracle-l Digest Users <oracle-l@xxxxxxxxxxxxx>,
Date: 12. 06. 2017 23:26
Subject: RE: Data pump run as sysdba
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
Jeff Smith says:
Try to run as SYS and see what happens.SYSDBA.
SQLDev will prevent you from doing so b/c of ‘unexpected’ behavior.
The data dictionary perspective changes drastically when going in as