Friday, May 6, 2016

Oracle Database 12c - DataPump (LOGTIME Parameter)

The LOGTIME parameter determines if timestamps should be included in the output messages from the expdp and impdp utilities.

LOGTIME=[NONE | STATUS | LOGFILE | ALL] 
The allowable values are explained below.

1. NONE : The default value, which indicates that no timestamps should be included in the output, 
   making the output look similar to that of previous versions.
2. STATUS : Timestamps are included in output to the console, but not in the associated log file.
3. LOGFILE : Timestamps are included in output to the log file, but not in the associated console messages.
4. ALL : Timestamps are included in output to the log file and console.
[oracle@localhost ddl]$ sqlplus /nolog

SQL> connect sys/oracle@orcl as sysdba

SQL> CREATE OR REPLACE DIRECTORY test_dir AS '/u01/app/oracle/oradata/';
Directory created.

SQL> GRANT READ, WRITE ON DIRECTORY test_dir TO scott;
Grant succeeded.

SQL> !expdp scott/oracle@orcl tables=emp directory=test_dir dumpfile=emp.dmp logfile=expdp_emp.log logtime=all

SQL> ! ls -lrt /u01/app/oracle/oradata/
total 192
-rw-r--r--. 1 oracle oinstall   1879 Nov  4 17:16 expdp_emp.log
-rw-r-----. 1 oracle oinstall 163840 Nov  4 17:16 emp.dmp

No comments:

Post a Comment