Friendly DBA: Sample Datapump Export and Import Scripts

Based on requirement, modify  Datapump Export and Import scripts 

[oracle@dg1 export]$ cat exp_oxford_schema.sh

TS_EXPORT=/u01/app/export

PWD=oracle

LOGFILE=exp_schema_oxford.log

ST=`date`

echo $PWD | expdp system directory=db_export  dumpfile=exp_schema_oxford.dmp  content=all logfile=$LOGFILE schemas=oxford job_name=exp_oxford

ET=`date`

echo "Start Time=$ST" >>$LOGFILE

echo "End Time=$ET" >>$LOGFILE

[oracle@dg2 export]$ cat impdp_oxford.sh 

DB_EXPORT=/u01/app/export

PWD=oracle

LOGFILE=imp_schema_oxford.log

ST=`date`

echo $PWD | impdp system directory=db_export  dumpfile=exp_schema_oxford.dmp content=all logfile=$LOGFILE schemas=oxford job_name=impdp_oxford remap_tablespace=oracle_tb:delta_tb

ET=`date`

echo "Start Time=$ST" >>$LOGFILE

echo "End Time=$ET" >>$LOGFILE

run your scripts in background using nohup  for example 

$ nohup ./impdp_oxford.sh & 

--Nikhil Tatineni--

--Datapump --