shell读取oracle表并输出为文件
export ORACLE_BASE=/opt/oracleexport ORACLE_HOME=/opt/oracle/product/11gR1/db
export ORACLE_SID=ORA
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:$ORACLE_HOME/rdbms/lib
export LD_LIBRARY_PATH
SHLIB_PATH=$ORACLE_HOME/lib32:$ORACLE_HOME/rdbms/lib32
export SHLIB_PATH
# Set shell search paths:
export PATH=$ORACLE_HOME/bin:/usr/sbin:$PATH:/usr/local/bin
#> CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
export> export DBCA_RAW_CONFIG=/opt/oracle/rawdevpath
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
export LANG=C
export LC_CTYPE=C
Day=`date-d "1 days ago" '+%Y%m%d'`
Month=`date-d "1 days ago" '+%Y%m'`
para1=`ps -ef | grep oracle | grep pmon | grep -v grep | awk '{print $8}'`;if [ ! -n "$para1" ]; then exit; fi
# sqlplus -s / as sysdba/home/oracle/shell/daily/dailyroute/dailyroute_${Day}
cat /home/oracle/shell/daily/tmp_dailyroute.lst | grep . >> /home/oracle/shell/daily/dailyroute/dailyroute_${Day}
exit 0
在excel表打开用分列选择逗号为分隔符。
页:
[1]