Re: /as sysdba insufficient privilege error
- From: Jared Still <jkstill@xxxxxxxxx>
- To: Guillermo Alan Bort <cicciuxdba@xxxxxxxxx>
- Date: Thu, 5 Feb 2009 11:05:37 -0800
Ah, I see the difference.
As Alok pointed out, without the quotes, the space is required.
With the quotes, it does not matter.
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
On Thu, Feb 5, 2009 at 9:12 AM, Jared Still <jkstill@xxxxxxxxx> wrote:
> 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:
