Linxu--导出oracle数据

配置导出的表:(configure.sh)

#!/bin/bash

function get_config() {
        tables=(
                BLOG
                WF_PROCESS
                WF_TASK
                WF_TASK_ACTOR
        )
        echo ${tables[@]}
}

主程序代码:(start.sh)

#!/bin/bash
 
source ./configure.sh
 
tables=$(get_config)
 
tmp_script=tmp/export.sh
 
for table in ${tables[@]}
do
        echo "**** ${table} **** "
        #echo "hello ${table} * !!" > ${file}
        #chmod +x ${file}
        echo "sqlplus -s 'SAJT_YUM/dzfp123@orcl' << "EOF"" > ${tmp_script}
        echo "EXEC sql_to_csv('select * from ${table}','OUT_PATH','${table}.csv')" >> ${tmp_script}
        echo "EOF" >> ${tmp_script}
        chmod +x ${tmp_script}
        ${tmp_script}
 
done
~           

oracle 导出数据的存储过程:

参考:http://blog.csdn.net/huangzhijie3918/article/details/72732816