read -p "Please keyin the directory name:" Di_name; export Di_name
read -p "Please keyin the oracle_username:" username; export username
read -p "Please keyin the oracle_password:" password; export password
<<EOF
sqlplus $username/$password
sql "create directory '${Di_name}' as '${DUMP_DIR}'";
sql "grant read,write on directory '${Di_name}' to '${username}'";
EOF
expdp $username/$password directory=${Di_name} dumpfile=${DUMP_FILE} logfile=${DUMP_LOG} schemas=${username}
sql语句不执行...sqlshell脚本oracle
read -p "Please keyin the oracle_username:" username; export username
read -p "Please keyin the oracle_password:" password; export password
<<EOF
sqlplus $username/$password
sql "create directory '${Di_name}' as '${DUMP_DIR}'";
sql "grant read,write on directory '${Di_name}' to '${username}'";
EOF
expdp $username/$password directory=${Di_name} dumpfile=${DUMP_FILE} logfile=${DUMP_LOG} schemas=${username}
sql语句不执行...sqlshell脚本oracle
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货