Schema EXPDP/IMPDP Parfiles

 There are couple of parameter which need to pass while doing export and import in NON Container database and Pluggable database.

Please find below sample parfiles.

1. Export parfile for non container database.

cat expdp_DBUSER_ORADB_10MAY2022.par

dumpfile=expdp_DBUSER_ORADB_10MAY2022_%U.dmp

logfile=expdp_DBUSER_ORADB_10MAY2022.log

job_name=expdp_DBUSER_ORADB_10MAY2022

schemas=DBUSER

directory=EXPDP

exclude=statistics

userid = '/ as sysdba'

parallel=8

Please follow below syntax to initiate the export backup in nohup mode.

nohup expdp PARFILE=expdp_DBUSER_ORADB_10MAY2022.par &

2. Import parfile for non container database.

cat impdp_DBUSER_ORADB_10MAY2022.par

dumpfile=expdp_DBUSER_ORADB_10MAY2022_%U.dmp

logfile=impdp_DBUSER_ORADB_10MAY2022.log

job_name=impdp_DBUSER_ORADB_10MAY2022

schemas=DBUSER

directory=EXPDP

exclude=statistics

userid = '/ as sysdba'

parallel=8

Please follow below syntax to initiate the import backup in nohup mode.

nohup impdp PARFILE=expdp_DBUSER_ORADB_10MAY2022.par &

3. Export parfile for pluggable database database.

cat expdp_DBUSER_PDB_10MAY2022.par

dumpfile=expdp_DBUSER_PDB_10MAY2022_%U.dmp

logfile=expdp_DBUSER_PDB_10MAY2022.log

job_name=expdp_DBUSER_PDB_10MAY2022

schemas=DBUSER

directory=EXPDP

exclude=statistics

parallel=8

Please follow below syntax to initiate the export backup in nohup mode.

nohup expdp \'system/password@PDB_NAME\' parfile=expdp_DBUSER_PDB_10MAY2022.par &