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: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 6 Oct 2000 20:08:22 +0200
Message-ID: <970895130.21606.0.pluto.d4ee154e@news.demon.nl>

sqlplus/nolog @NewDBrun.sql
and include an exit as the last line in the sql script Also you shouldn't use internal anymore, it is obsolete. Use connect / as sysdba instead.

Hth,

Sybrand Bakker, Oracle DBA

"doug edmunds" <dae_alt3_at_juno.com> wrote in message news:8FC563CDADougEdmunds_at_199.2.117.165...
> 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 - 13:08:22 CDT

Original text of this message

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