Sample Datapump Scripts

[oracle@red export]$ cat expddl_mots_schema.sh
TS_EXPORT=/u01/app/export
PWD=oracle
LOGFILE=exp_schema_mots_ddl.log
ST=`date`
echo $PWD | expdp system directory=ts_export  dumpfile=exp_schema_mots_ddl.dmp  content=METADATA_ONLY logfile=$LOGFILE schemas=mots job_name=expddl_schema_mots
ET=`date`
echo "Start Time=$ST" >>$LOGFILE
echo "End Time=$ET" >>$LOGFILE

[oracle@red export]$ cat expdata_mots_schema.sh 
TS_EXPORT=/u01/app/export
PWD=oracle
LOGFILE=exp_schema_mots_data.log
ST=`date`
echo $PWD | expdp system directory=ts_export  dumpfile=exp_schema_mots_data.dmp  content=data_only logfile=$LOGFILE schemas=mots job_name=expdata_schema_mots
ET=`date`
echo "Start Time=$ST" >>$LOGFILE
echo "End Time=$ET" >>$LOGFILE

[oracle@red export]$ nohup ./expdata_mots_schema.sh &

[1] 4888

[oracle@red export]$ nohup: appending output to `nohup.out'

[oracle@red export]$ jobs
[1]+  Running                 nohup ./expdata_mots_schema.sh &

--Nikhil Tatineni--
--Oracle In Memory--