Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Executing a SQL from svrmgr from command line

Re: Executing a SQL from svrmgr from command line

From: no spam <no_at_spam.com>
Date: Wed, 17 Nov 1999 18:42:10 GMT
Message-ID: <6GCY3.32491$m4.112016621@news.magma.ca>


create shell script like the following

svrmgr30.exe @e:\sample.sql

in the sql file login and put sql statements

connect scot/tiger
select table_name from user_tables;

Praveen Mohanan wrote in message
<942861734.224930_at_sj-nntpcache-2.cisco.com>...
>TO DBA GURUS,
>
>
> I wanted to execute one few commands from the command line & exit at the
>end. For eg
>
>1. invoke srvmgr
>2. connect internal
>3. run a SQL script
>4. exit
>
>How can i write this in a shell script, so that if i call the shell, it
will
>run all these command & come back to the prompt.
>
>
>Regards
>
>
Received on Wed Nov 17 1999 - 12:42:10 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US