Home » Infrastructure » Unix » oracle script in background using nohup in Unix ??
oracle script in background using nohup in Unix ?? [message #97494] Mon, 24 June 2002 07:57 Go to next message
Sameer
Messages: 60
Registered: March 1998
Member
Can anybody help me out in executing an oracle sql script through unix using a nohup command.

Thanks in advance.

Sameer
Re: oracle script in background using nohup in Unix ?? [message #97495 is a reply to message #97494] Mon, 24 June 2002 08:40 Go to previous messageGo to next message
ecpdba
Messages: 4
Registered: June 2002
Junior Member
./script.sh nohup
Re: oracle script in background using nohup in Unix ?? [message #97497 is a reply to message #97494] Tue, 25 June 2002 08:56 Go to previous message
Grant
Messages: 578
Registered: January 2002
Senior Member
One Method:

In myscript.ksh:
#make sure to add all your environment variables
sqlplus system/manager @mysql.sql

In mysql.sql:
sql statement
exit

At the unix prompt:
./myscript.ksh nohup
Previous Topic: using at command to submit oracle commands
Next Topic: grepping a database
Goto Forum:
  


Current Time: Thu Oct 01 02:47:41 CDT 2020