OraFAQ Forum: Unix » oracle script in background using nohup in Unix ??

Home » Infrastructure » Unix » oracle script in background using nohup in Unix ??

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

oracle script in background using nohup in Unix ?? [message #97494]

Mon, 24 June 2002 07:57

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

Report message to a moderator

Re: oracle script in background using nohup in Unix ?? [message #97495 is a reply to message #97494]

Mon, 24 June 2002 08:40

ecpdba
Messages: 4
Registered: June 2002

Junior Member

./script.sh nohup

Report message to a moderator

Re: oracle script in background using nohup in Unix ?? [message #97497 is a reply to message #97494]

Tue, 25 June 2002 08:56

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

Report message to a moderator

Previous Topic:	using at command to submit oracle commands
Next Topic:	grepping a database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 20 00:33:57 CDT 2024