FLASHBACK_TIME Has Format 'YY-MON-DD HH:MI:SS AM' When Querying DataPump Job Status (Doc ID 2229709.1)

Last updated on FEBRUARY 02, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 and later
Information in this document applies to any platform.

Goal

Attaching to a DataPump job started with:

FLASHBACK_TIME=TO_TIMESTAMP(TO_CHAR(SYSDATE,'YYYY-MM-DD HH24:MI:SS'),'YYYY-MM-DD HH24:MI:SS')

the output shows that Data Pump converts flashback_time into 'YY-MON-DD HH:MI:SS AM' format:

[oracle@d01pexadb02 EDWPRD]$ expdp system/password attach=SYS_EXPORT_SCHEMA_01

Export: Release 11.2.0.4.0 - Production on Mon Jan 30 12:43:41 2017

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

Job: SYS_EXPORT_SCHEMA_01
Owner: SYS
Operation: EXPORT
Creator Privs: TRUE
GUID: 475459B8DF678D7AE0530B850B0A052A
Start Time: Monday, 30 January, 2017 12:43:18
Mode: SCHEMA
Instance: edwprd2
Max Parallelism: 1
EXPORT Job Parameters:
Parameter Name Parameter Value:
CLIENT_COMMAND "/******** AS SYSDBA" directory=expdp dumpfile=test2.dmp logfile=test2.log SCHEMAS=ABC flashback_time="TO_TIMESTAMP (TO_CHAR (sysdate, 'YYYY-MM-DD HH24:MI:SS'), 'YYYY-MM-DD HH24:MI:SS')"
FLASHBACK_TIME 17-JAN-30 12:43:18 PM
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Dump File: /pshare2/exports/EDWPRD/test2.dmp
bytes written: 102,400

As one can see from the DataPump Master (DM) trace collected with trace=1FF0300 set, DataPump Utility calls internally the following query to determine the flashback_time value:

 
Why DataPump converts flashback_time value into 'YY-MON-DD HH:MI:SS AM' format even if a different format was set in the command line?

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms