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 &
Posted by rkorclappsdbastuff at 5:04 AM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2019 (2)
    • ►  September (1)
    • ►  March (1)
  • ►  2018 (3)
    • ►  July (2)
    • ►  February (1)
  • ►  2017 (11)
    • ►  December (3)
    • ►  November (5)
    • ►  October (3)
  • ►  2016 (4)
    • ►  November (2)
    • ►  October (1)
    • ►  September (1)
  • ►  2015 (41)
    • ►  December (2)
    • ►  October (2)
    • ►  September (5)
    • ►  August (7)
    • ►  July (5)
    • ►  June (2)
    • ►  May (9)
    • ►  April (5)
    • ►  March (3)
    • ►  February (1)
  • ►  2014 (15)
    • ►  December (1)
    • ►  October (3)
    • ►  August (1)
    • ►  July (1)
    • ►  June (8)
    • ►  May (1)
  • ▼  2013 (40)
    • ►  December (1)
    • ►  September (1)
    • ►  July (8)
    • ►  June (18)
    • ►  May (2)
    • ►  April (1)
    • ▼  March (4)
      • Unrecognized option: -nojit Could not create the J...
      • how to check printer status in linux
      • Script to execute a sql file in background.
      • Upgrading EBS R12 11gR1 RAC to 11gR2 RAC
    • ►  January (5)

About Me

rkorclappsdbastuff
View my complete profile
Picture Window theme. Powered by Blogger.