<<Back to Oracle DATAPUMP Main Page
LOGFILE and LOGTIME in Expdp and Impdp
LOGFILESpecifies the name of export/import logfile
Default: export.log
Syntax and DescriptionLOGFILE=[directory_object:]file_name
LOGTIME
Specifies that messages displayed during export operations be timestamped. Using timestamp in logfile you can investigate which operation took what time.
Default:NONE <= No timestamps are recorded
Syntax and DescriptionLOGTIME=[NONE | STATUS | LOGFILE | ALL]
• STATUS--Timestamps on status messages only
• LOGFILE--Timestamps on log file messages only
• ALL--Timestamps on both status and log file messages
An Example
$ cat exp_full_pdb01.par
DIRECTORY=DUMP
DUMPFILE=EXP_PDB01_FULL%U.DMP
LOGFILE=EXP_PDB01_FULL.LOG
FULL=Y
REUSE_DUMPFILES=Y
FLASHBACK_TIME=SYSTIMESTAMP
LOGTIME=ALL
$ expdp system@PDB01 parfile=exp_full_pdb01.par
Export: Release 12.2.0.1.0 - Production on Fri Oct 26 11:53:35 2018
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
Password:
Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
26-OCT-18 11:55:22.532: Starting "SYSTEM"."SYS_EXPORT_FULL_02": system/********@PDB01 parfile=exp_full_pdb01.par
26-OCT-18 12:04:39.924: Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
.................................................................................................................................................
.................................................................................................................................................26-OCT-18 12:30:18.303: . . exported "TEST"."PEOPLE" 6.796 KB 1 rows
26-OCT-18 12:30:20.304: . . exported "TEST2"."EXP_TEST" 5.585 KB 9 rows
26-OCT-18 12:30:40.305: Master table "SYSTEM"."SYS_EXPORT_FULL_02" successfully loaded/unloaded
26-OCT-18 12:30:42.326: ******************************************************************************
26-OCT-18 12:30:44.303: Dump file set for SYSTEM.SYS_EXPORT_FULL_02 is:
26-OCT-18 12:30:46.306: /u01/dbatst2/stage/dump/EXP_PDB01_FULL01.dmp
26-OCT-18 12:30:50.321: Job "SYSTEM"."SYS_EXPORT_FULL_02" successfully completed at Fri Oct 26 12:30:50 2018 elapsed 0 00:36:58
If you want and export or import do not create a logfile use NOLOGFILE=YES parameter
Default: NO <= means export/import will create the logfile
Syntax and Description
NOLOGFILE=[YES | NO]
Comments
Post a Comment