OraFAQ Forum: Unix » using at command to submit oracle commands

Home » Infrastructure » Unix » using at command to submit oracle commands

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

using at command to submit oracle commands [message #97478]

Wed, 05 June 2002 11:43

Toyn
Messages: 36
Registered: April 2001

Member

Hi,
I'm using the below syntax:
$ at 1500 < test >> test.out
for my file. As a test for using this at command with Oracle my test file looks like the below:
sqlplus test/test1
desc test

What's happening is the file is opening sqlplus, and then closing it before I can get to the command.

Connected to:
Oracle8 Enterprise Edition Release 8.0.5.1.0 - Production
PL/SQL Release 8.0.5.1.0 - Production

SQL> Disconnected from Oracle8 Enterprise Edition Release 8.0.5.1.0 - Production
PL/SQL Release 8.0.5.1.0 - Production
desc: Command not found

How can I instruct at, or properly write my file to ensure that oracle stays open so I can execute my commands? Thanks.

Report message to a moderator

Re: using at command to submit oracle commands [message #97479 is a reply to message #97478]

Wed, 05 June 2002 15:34

andrew again
Messages: 2577
Registered: March 2000

Senior Member

Write your commands to a sql script and then call that on the sql command line. Try the following:

sqlplus -s test/test1 @myfile.sal >> test.out

You can also use "here documents". See the URL below (see the EOF tags. Some shells want the closing tag (EOF) to be in column 1 so no indenting allowed.)

http://www.orafaq.net/msgboard/unix/messages/1319.htm

Report message to a moderator

Re: using at command to submit oracle commands [message #97490 is a reply to message #97479]

Thu, 20 June 2002 10:38

andrew again
Messages: 2577
Registered: March 2000

Senior Member

I haven't tested these but you could try them:
at now sqlplus -s test/test1 @myfile.sal >> test.out
sqlplus -s test/test1 @myfile.sal >> test.out &
nuhup sqlplus -s test/test1 @myfile.sal >> test.out

Report message to a moderator

Previous Topic:	Oracle's interaction with Unix.
Next Topic:	oracle script in background using nohup in Unix ??

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 05 11:03:37 CST 2025