Re: /as sysdba insufficient privilege error

Adding a space caused it to work.

Interesting, but not terribly important. :)

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

On Thu, Feb 5, 2009 at 2:37 AM, Guillermo Alan Bort <cicciuxdba_at_gmail.com>wrote:

> Actually, it's not.
>
> [oracle_at_aurora ~]$ sqlplus "/as sysdba"
>
> SQL*Plus: Release 10.2.0.3.0 - Production on Thu Feb 5 07:36:44 2009
>
> Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
>
>
> Connected to:
> Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
> With the Partitioning, OLAP and Data Mining options
>
> SQL>
>
>
> if you loose the ", then the space is necessary indeed.
>
> hth
> Alan Bort
> Oracle Certified Associate
>
>
>
> On Wed, Feb 4, 2009 at 11:38 PM, Jared Still <jkstill_at_gmail.com> wrote:
> >
> > On Wed, Feb 4, 2009 at 3:56 PM, Mike Haddon <m.haddon_at_tx.rr.com> wrote:
> >>
> >> Just a thought but in Unix, isn't there supposed to be a space between
> the
> >> / and as I.E "/ as sysdba"
> >
> > Nice catch - yes, a space is required.
> >
> > At least on 10g it is.
> >
> >
> >
>

--
http://www.freelists.org/webpage/oracle-l