Introduction: –  As Oracle user, we are learning Oracle export/import from 9i still changes are going on. 12c has introduced LOGTIME=ALL Parameter In Datapump. We are going to know about LOGTIME=ALL Parameter In Datapump in 12c. Data Pump Export is a utility for unloading data and metadata into a set of operating system files called a dump file set. The dump file set can be imported only by the Data Pump Import utility. The dump file set can be imported on the same system or it can be moved to another system and loaded there.

LOGTIME: Specifies that messages displayed during export operations be timestamped. It has been introduced in Oracle 12c.

Valid keyword values are ALL, [NONE], LOGFILE and STATUS.
EXAMPLE:

[oracle@localhost ~]$ expdp dumpfile=logdump.dmp logfile=viewlog.log directory=DUMP schemas=TEST logtime=ALL

Export: Release 12.1.0.2.0 - Production on Sat Aug 22 07:19:41 2015

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

Username: sys/oracle@ORCL as sysdba

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
22-AUG-15 07:19:51.752: Starting "SYS"."SYS_EXPORT_SCHEMA_02": sys/********@ORCL AS SYSDBA dumpfile=logdump.dmp logfile=viewlog.log directory=DUMP schemas=TEST logtime=ALL
22-AUG-15 07:19:52.687: Estimate in progress using BLOCKS method...
22-AUG-15 07:19:55.163: Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
22-AUG-15 07:19:55.244: Total estimation using BLOCKS method: 39 MB
22-AUG-15 07:19:55.776: Processing object type SCHEMA_EXPORT/USER
22-AUG-15 07:19:55.937: Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
22-AUG-15 07:19:55.971: Processing object type SCHEMA_EXPORT/ROLE_GRANT
22-AUG-15 07:19:56.014: Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
22-AUG-15 07:19:56.687: Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
22-AUG-15 07:20:05.095: Processing object type SCHEMA_EXPORT/TABLE/TABLE
22-AUG-15 07:20:08.467: Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
22-AUG-15 07:20:08.719: Processing object type SCHEMA_EXPORT/STATISTICS/MARKER
22-AUG-15 07:20:20.538: . . exported "TEST"."TEST" 10.66 MB 93925 rows
22-AUG-15 07:20:20.763: . . exported "TEST"."TEST2" 10.66 MB 93937 rows
22-AUG-15 07:20:21.072: . . exported "TEST"."TEST3" 10.66 MB 93938 rows
22-AUG-15 07:20:21.926: Master table "SYS"."SYS_EXPORT_SCHEMA_02" successfully loaded/unloaded
22-AUG-15 07:20:21.928: ******************************************************************************
22-AUG-15 07:20:21.929: Dump file set for SYS.SYS_EXPORT_SCHEMA_02 is:
22-AUG-15 07:20:21.932: /home/oracle/DUMP/logdump.dmp
22-AUG-15 07:20:21.957: Job "SYS"."SYS_EXPORT_SCHEMA_02" successfully completed at Sat Aug 22 07:20:21 2015 elapsed 0 00:00:32

[oracle@localhost ~]$

 

The date/time information can be used to see how long it takes for specific objects to be exported, useful for planning production runtimes.

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.