Re: Getting rid of INTERNAL id..

From: fro_doe <fro_doeNOfrSPAM_at_hotmail.com.invalid>
Date: 2000/07/19
Message-ID: <0004bdec.51781de3@usw-ex0103-018.remarq.com>#1/1

You have to connect to the database as SYSDBA for the privileges to be in effect. However, you do not need a password file (at least on UNIX systems). You can simply replace:

% sqlplus internal

with:

% sqlplus '/ as sysdba'

Or at the SQL prompt

SQL> connect internal
with:

SQL> connect / as sysdba

In your case, if you want to use the SYSTEM user, for example, you would need to do this:

SQL> connect system as sysdba

Doug.

Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free!
http://www.keen.com Received on Wed Jul 19 2000 - 00:00:00 CDT