Wednesday, 21 October 2015

Create a shell script to run export/import utilities.



You want to create a shell script to run export/import utilities. 


# SCRIPT 
# ---------
# 
# Set environment variables for ORACLE_HOME, ORACLE_SID, 
# and DUMPDIR -- in case of datapump --, as well as PATH if needed.
#
#

trap '' 1 # to use nohup in a shell script 

# Set these to appropriate values if needed:
#
#ORACLE_HOME=
#ORACLE_SID= 
#DUMPDIR= 

# Customize PATH if needed 
#
#PATH=/bin:/usr/bin:${ORACLE_HOME}/bin:/usr/local/bin:/usr/lbin 

#export ORACLE_HOME ORACLE_SID PATH 

echo "Exporting $ORACLE_SID database. start `date`" 
# 
expdp system/password dumpfile=scott.dmp directory=DUMPDIR schemas=scott logfile=scott.log
#
echo "Export of $ORACLE_SID database completed at `date`" 

#End of Script

No comments:

Post a Comment

The purge process did not run because the Oprid configured to start the Process Scheduler did not have the required permissions to run the purge process.

  Purge process - Required permissions The PeopleSoft Oprid used to start the Process Scheduler, as defined in the Scheduler's psprcs.cf...