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.
