Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: svrmgr23 on NT
Once you have called svrmgr23, that program will be executing. The next
command in the batch file (your connect statement) will not get executed
until you exit svrmgr23. If you want to have statements executed within
svrmgr23 you need to create a seperate SQL script file and call that from
the svrmgr23 statement.
Example : Batch file :
set oracle_sid=dba svrmgr23 @test.sql
Example : SQL "test.sql" script file:
connect internal/oracle
select * from dual;
exit
Dave
Luc Demanche wrote:
> I would like to use svrmgr23 on batch file. I can call svrmgr23 but I
> can't do any sql commands in svrmgr23.
>
> Example : I have in a batch file :
> set oracle_sid=dba
> svrmgr23
> connect internal/oracle
>
> The connect command don't work. WHY?
>
> Can you help me please ?
>
> Luc Demanche
> demanchel_at_icotech.com
Received on Tue Sep 22 1998 - 07:40:31 CDT
![]() |
![]() |