Home » Infrastructure » Unix » using unix commands within an SQL script.
using unix commands within an SQL script. [message #1346] Tue, 23 April 2002 06:33 Go to next message
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.
Re: using unix commands within an SQL script. [message #1347 is a reply to message #1346] Tue, 23 April 2002 07:05 Go to previous message
Mahesh Rajendran
Messages: 10706
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
use host command to redirect the control to unix and issue the unix command from therre.

create table...
create ...
host unix comm
exit from unix
continue your sql..
Previous Topic: Where is automatic dbstart & listener start ??
Next Topic: Re: How do I Mount a Database on Startup?
Goto Forum:

Current Time: Fri Jun 02 01:06:56 CDT 2023