Here I am exploring two new Oracle datapump parameters that have been introduced in Oracle 12cR1 (12.1.0.2). They are: views_as_tables & logtime.
views_as_tables : will allow you to export the specified schema views as tables.
Logtime: will provide timestamp for each operation being performed while pump operations is running (in my opinion: very useful).
Export datapump command using both parameters example:
nohup $ORACLE_HOME/bin/expdp “‘/as sysdba ‘” DIRECTORY=PUMP_DIR DUMPFILE=test_view_as_table.dmp views_as_tables=SM_DEV.ANAL_COMP_VIEW logfile=export_table_as_view.log logtime=all &
***** If you face the below error while performing expdp with “logtime” parameter:
UDE-31623: operation generated ORACLE error 31623
ORA-31623: a job is not attached to this session via the specified handle
ORA-06512: at “SYS.DBMS_DATAPUMP”, line 3905
ORA-06512: at “SYS.DBMS_DATAPUMP”, line 5203
ORA-06512: at line 1
***** To resolve this problem I have checked the following:
1.I have checked that the streams parameter and it was beyond 40M which is OK.
- Then, I have checked that all my database components are valid using the query:
select * from dba_registry;
3. The final resolution was to unset NLS_LANG environment variable.
Which solved my error problems!!!
To return back to our initial thread, When you check the content of the log file the time stamps are included which is useful to check the process that is consuming more time.
here is an example of export logfile with time stamp dates added:
