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
Friday, May 6, 2016
Oracle Database 12c - DataPump (LOGTIME Parameter)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment