Re: Using Sqlplus instead of Svrmgrl

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