Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Getting rid of INTERNAL id..

Re: Getting rid of INTERNAL id..

From: <vasarpota_at_my-deja.com>
Date: 2000/07/20
Message-ID: <8l6vp4$k4s$1@nnrp1.deja.com>#1/1

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

Original text of this message

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