定时任务施行sqlldr

2012-12-28

定时任务执行sqlldr#!/bin/kshexport ORACLE_SIDtestexport ORACLE_BASE/opt/oracle/dbexport ORACLE_HO

定时任务执行sqlldr
#!/bin/ksh

export ORACLE_SID=test
export ORACLE_BASE=/opt/oracle/db
export ORACLE_HOME=/opt/oracle/db/product/11.1.0
export PATH=$ORACLE_HOME/bin:$PATH

sqlldr username/passwd@tns control="test.ctl"