Hi I'm creating a script to refresh oracle schema. While trying to backup the schema I kept getting the error below. I have searched everywhere and no one seems to be having this same exact error. Any advise?
The EXP_IMP_DIR is a non default datapump directory created by my script before the below function is ran, so the directory is there for sure.
#!/bin/ksh
systemPwd=pwd
srcSID=src
tarSID=tar
srcSCHEMA=A
tarSCHEMA=A
export_source_schema(){
echo
echo -------------------------
echo "EXPORTING SOURCE SCHEMA"
echo -------------------------
expdp system/${systemPwd}@${srcSID} SCHEMAS=${srcSCHEMA} DIRECTORY=EXP_IMP_DIR DUMPFILE=${taskNo}_${srcSID}_${srcSCHEMA}_export.dmp LOGFILE=${taskNo}_${srcSID}_${srcSCHEMA}_export.log
}
./export_schema.ksh
-------------------------
EXPORTING SOURCE SCHEMA
-------------------------
LRM-00116: syntax error at 'DIRECTORY' following '='
./export_schema.ksh[502]: break: cannot break