rkorclappsdbastuff’s
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment