f_get_tables() { rm -f ${lv_temp1} sqlplus ${userid} <<! >/dev/null set colsep $sep; set echo off; set feedback off; set heading off; set pagesize 0; set linesize 1000; set numwidth 12; set termout off; set trimout on; set trimspool on; spool ${lv_temp1}; select table_name from user_tables; spool off; exit ! if [ "$?" -ne 0 ] then echo "Error:sqlplus ${userid} error in load for ${userid} !" echo "please check userid and passwd or oracle_sid." exit fi
if [ -f ${lv_temp1} ] then lv_tables=`cat ${lv_temp1} grep -v "^SQL>" tr -d ' '` else echo "Error:${lv_temp1} file not found!" exit fi
case ${lv_no} in 1 userid=$1 f_get_tables; ;; 2 userid=$1 lv_tables=$2 ;; * echo "Usage: $0 <userid/passwd[@connection]> <table_name>" exit ;; esac
for lv_table in ${lv_tables} do if [ ! -f ${lv_table}.unl ] then echo "Error:${lv_table}.unl file not found!" else generate_control_file.sh ${userid} ${lv_table} generate_execute_shell.sh ${userid} ${lv_table} sh load_${lv_table}.sh rm -f ${lv_table}.ctl
精品推荐
