Re: /as sysdba insufficient privilege error
- From: Jared Still <jkstill@xxxxxxxxx>
- To: Guillermo Alan Bort <cicciuxdba@xxxxxxxxx>
- Date: Thu, 5 Feb 2009 09:12:32 -0800
Actually I tried it before replying, and it didn't work.
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@xxxxxxxxx>wrote:
> Actually, it's not.
>
> [oracle@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@xxxxxxxxx> wrote:
> >
> > On Wed, Feb 4, 2009 at 3:56 PM, Mike Haddon <m.haddon@xxxxxxxxx> 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.
> >
> >
> >
>
Other related posts:
