Datapump expdp impdp New Feature – Print Content of Parfile to Logfile

advertisements

_____________________________________________________________________________________________________________________

From Oracle 12.2 release onwards, when you use the parfile option to expdp or impdp it will write the content of the parfile to the logfile in below format.

So, user don’t need to check the parfile explicitly in the later stage. Also, you don’t need to save the copy of the parfile. 

;;; ************************************************************************** ;;; Parfile values: ;;; parfile: schemas=test 

Demo 
Content of parfile

$ cat exp.par
userid=test/test
job_name=tab_export
directory=EXP_DIR
dumpfile=TST_table_exp.dmp
logfile=TST_tab_exp.log
REUSE_DUMPFILES=y
schemas=test

advertisements

 

Content of logfile

;;
Export: Release 19.0.0.0.0 - Production on Mon Jul 20 04:43:03 2020
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.
;;;
Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
;;; **************************************************************************
;;; Parfile values:
;;;  parfile:  schemas=test
;;;  parfile:  reuse_dumpfiles=Y
;;;  parfile:  logfile=TST_tab_exp.log
;;;  parfile:  dumpfile=TST_table_exp.dmp
;;;  parfile:  directory=EXP_DIR
;;;  parfile:  job_name=tab_export
;;;  parfile:  userid=/******** AS SYSDBA
;;; **************************************************************************
Starting "SYS"."TAB_EXPORT":  /******** AS SYSDBA parfile=exp.par
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Connect to Oracle Database Running in Linux 

_____________________________________________________________________________________________________________________

Website Stats