vi runshell.sh ------> backgroud
#!/bin/sh
sqlplus -s /nolog << EOF
connect p105367/Chair01
show parameter db_name;
spool oms_arc_O01OMS3_remove.log
set sqlblanklines on
set serveroutput on time on feedback on
set time on
set echo on
alter session set current_schema=PLMSSC;
@/auto/users-04/e433559/oms_arc_O01OMS3_remove.sql
commit;
spool off
exit;
EOF
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
./runshell.sh & ---> 即是在后台运行.
================
或另一种格式：
set serveroutput on
set echo on;
set define off;
set serveroutput on linesize 30000;
set timing on;
set time on;
spool /tmp/master_script_de1.log
select global_name from global_name;
select user from user_users;
select sysdate from dual;
@de_entity_extr_de_tmp.ddl
show errors
@pkg_de_extract.sql
show errors
@insert_de_entity_extr_de.sql
show errors
spool off;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/22578826/viewspace-709890/ ，如需转载，请注明出处，否则将追究法律责任。
