Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Getting rid of INTERNAL id..
Got it! - Thanks!
In article <0004bdec.51781de3_at_usw-ex0103-018.remarq.com>,
fro_doe <fro_doeNOfrSPAM_at_hotmail.com.invalid> wrote:
> 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
>
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Thu Jul 20 2000 - 00:00:00 CDT