Wednesday, March 20, 2013

Script to execute a sql file in background.


script1.sh
======

sqlplus -s "uname/passwd" <<EOF > "logfile_name.txt"
Prompt Description of the script
Prompt
set head on;
commit;
@/ora/oracle/app1/filename.sql;
commit;
exit;
EOF
exit


bash-3.00$nohup sh script1.sh &

No comments:

Post a Comment