shell指令碼的一則簡單運用案例

因一現網問題需將特定日期內的表日誌資料匯出供分析，我協助提供瞭如下的shell指令碼：

[@more@]

#!/usr/bin/sh
cd /oracle

#create user
sqlplus -s /nolog </dev/null
connect portal/portal
drop table op_log_syh;
create table op_log_syh as select * from op_log
where to_char(op_date,'yyyymmdd') in ('20071008','20071009','20071010','20071011');
exit;
EOF
echo 'Geted the need data from table OP_LOG.'

$ORACLE_HOME/bin/exp portal/portal file=/oracle/op_log_syh.dmp tables=op_log_syh consistent=y buffer=50000000 triggers=n statistics=none grants=n log=/oracle/op_log_syh.log

echo 'Completed the export.'

sqlplus -s /nolog </dev/null
connect portal/portal
drop table op_log_syh;
exit;
EOF