重庆思庄Oracle、、PostgreSQL、Redhat认证学习论坛

标题: LRM-00116: ')' followed by 'yyyy-mm-dd' FOR ORACLE 11G EXPDP [打印本页]

作者: mahan 时间: 2024-8-1 15:08
标题: LRM-00116: ')' followed by 'yyyy-mm-dd' FOR ORACLE 11G EXPDP
#!/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

解决办法：检查/home/oracle/.bash_profile设置的变量信息

欢迎光临重庆思庄Oracle、、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/)