OraFAQ Forum: Server Administration » how to execute a bat file for sqlplus???

Home » RDBMS Server » Server Administration » how to execute a bat file for sqlplus???

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

how to execute a bat file for sqlplus??? [message #57945]

Mon, 21 July 2003 16:51

fengq
Messages: 38
Registered: October 2002

Member

Hi all. I have a bat file below:

sqlplus useid/password@list
spool d:feng.txt
select * from v$database;
spool off;

but when it executes, it always stop after sqlplus logging, how can I execute the whole thing??

thanks

Report message to a moderator

Re: how to execute a bat file for sqlplus??? [message #57948 is a reply to message #57945]

Mon, 21 July 2003 17:59

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

Senior Member
Account Moderator

have all your sqlplus plus commands in the file and call it in the command line.
-- let these be in the file a.sql
spool d:feng.txt
 -- add any sql*plus formating commands
select * from v$database;
spool off;
exit;

-- now call it from command prompt
sqlplus useid/password@list @a.sql

Report message to a moderator

Previous Topic:	Oracle Initialization or Shutdown in Progress
Next Topic:	ORA-03113 caused by ORA-00600 on WindowsNT

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 11:30:53 CDT 2024