My Oracle Support Banner

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

Last updated on MAY 18, 2021

Applies to:

Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


Attaching to a DataPump job started with:


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 - 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 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

Owner: SYS
Operation: EXPORT
Creator Privs: TRUE
GUID: 475459B8DF678D7AE0530B850B0A052A
Start Time: Monday, 30 January, 2017 12:43:18
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
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Dump File: <path & file name>.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?


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.