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: sysdba login

Re: sysdba login

From: David Fitzjarrell <oratune_at_aol.com>
Date: Mon, 29 Jan 2001 22:41:37 GMT
Message-ID: <954riv$lm3$1@nnrp1.deja.com>

In our last gripping episode amana32_at_my-deja.com wrote:
> There is difference in SYSDBA role and a user named as SYSDBA. First
 of
> all one should avoid using such reserved words and male situation
> complex. Better create a different user and use oracle utility to
> export and import entire schema.
>
> Aaman
>
> In article <953klg$hnv$1_at_nnrp1.deja.com>,
> gorgos_at_my-deja.com wrote:
> > Hello all,
> > I've inherited an application that has a schema called sysdba! I've
> > also got a user who wishes to be able to login as sysdba using
 SQLPLUS
> > 8.1.5 but he gets the error:
> >
> > SP2-0306: Invalid option.
> > Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}] | [INTERNAL]
> > where <logon> ::= <username>[/<password>][@<connect_string>] | /
> >
> > Is there any way around this ? svrmgrl is not an option, as he
 can't
> > access the server.
> >
> > This apparantly works in 8.0.4.
> >
> > Thanks
> >
> > Sent via Deja.com
> > http://www.deja.com/
> >
>
> Sent via Deja.com
> http://www.deja.com/
>

So, just what exactly IS "male situation complex"?

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com
http://www.deja.com/
Received on Mon Jan 29 2001 - 16:41:37 CST

Original text of this message

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