--bat content begin--
sqlplus / as sysdba @b.sql
--bat content end--
b.sql content as follow:
select count(*) from tab;
sqlplus / as sysdba @b.sql
--bat content end--
b.sql content as follow:
select count(*) from tab;
-------------------------
$SQLPLUS_CMD $USERID >/dev/null <<EOF ----不懂的地方
spool ${BATCH_HOME}/tmp/truncall.log
@${EXPIMP_PATH}/truncall
spool off
exit
EOF
两个EOF之间的内容作为$SQLPLUS_CMD $USERID 的输入
spool ${BATCH_HOME}/tmp/truncall.log
@${EXPIMP_PATH}/truncall
spool off
exit
EOF
两个EOF之间的内容作为$SQLPLUS_CMD $USERID 的输入