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 -> Using Sqlplus instead of Svrmgrl

Using Sqlplus instead of Svrmgrl

From: doug edmunds <dae_alt3_at_juno.com>
Date: 6 Oct 2000 10:30:57 PST
Message-ID: <8FC563CDADougEdmunds@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:30:57 CDT

Original text of this message

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