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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Using Sqlplus instead of Svrmgrl

Re: Using Sqlplus instead of Svrmgrl

From: frank <fbortel_at_home.nl>
Date: Fri, 06 Oct 2000 20:26:27 GMT
Message-ID: <39DE3387.DB887002@home.nl>

change the script files:
connect internal/oracle to: connect system/manager as sysdba

doug edmunds wrote:

> In the Getting to Know Oracle (8.1.6) manual, it says
>
> "Server Manager Desupport ---
>
> The Server Manager will be desupported in a future
> release of Oracle. You should begin
> to migrate your Server Manager SQL scripts
> to SQL*Plus scripts as soon as possible."
>
> How do you convert something like the file that
> sets up a new database, which has lines like this:
>
> svrmgrl @NewDBrun.sql
> svrmgrl @NewDBrun2.sql
> svrmgrl @NewDBalterTablespace.sql
>
> where the login information is contained inside the sql file
> and where the program automatically exits after running each?
>
> (Those auto-generated sql files have 'connect internal/oracle'
> statements embedded in them, which provides the login for svrmgrl,
> and svrmgrl closes automatically after each line is run.)
>
> Thanks.
>
> --
> Doug Edmunds
> Vancouver, Washington USA
> edmunds::at::pacifier::dot::com
Received on Fri Oct 06 2000 - 15:26:27 CDT

Original text of this message

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