OraFAQ Forum: Unix » using unix commands within an SQL script.

Home » Infrastructure » Unix » using unix commands within an SQL script.

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

using unix commands within an SQL script. [message #1346]

Tue, 23 April 2002 06:33

Andrew Ford
Messages: 18
Registered: November 2001

Junior Member

Is there any way that you can issue unix commands from within an sql script? I am trying to write a script that will shutdown the database, use unix copy commands to copy operating system files and then start the database back up again.

Report message to a moderator

Re: using unix commands within an SQL script. [message #1347 is a reply to message #1346]

Tue, 23 April 2002 07:05

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

yeah!
use host command to redirect the control to unix and issue the unix command from therre.

create table...
create ...
sql1...
host unix comm
exit from unix
continue your sql..

Report message to a moderator

Previous Topic:	Where is automatic dbstart & listener start ??
Next Topic:	Re: How do I Mount a Database on Startup?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 20 06:58:50 CDT 2024