Re: ORA-1031 when privileges have been granted

From: Jason Heinrich <jheinrichdba_at_gmail.com>
Date: Tue, 13 Jan 2009 14:36:12 -0600
Message-ID: <b32e774d0901131236t5a85eef5v424e41084cb33867_at_mail.gmail.com>



Resolved.

As I had suspected, dataguard was the culprit. After issuing an 'alter database guard none' everything created and ran fine.

On Fri, Jan 9, 2009 at 12:32 PM, Jared Still <jkstill_at_gmail.com> wrote:

>
> On Fri, Jan 9, 2009 at 8:19 AM, Jason Heinrich <jheinrichdba_at_gmail.com>wrote:
>
>> SQL> create type varchar2_table as table of varchar2(2000);
>> 2 /
>> create type varchar2_table as table of varchar2(2000);
>> *
>> ERROR at line 1:
>> ORA-01031: insufficient privileges
>>
>
> It appears that something is broke, not just a permissions problem.
>
> This if course is not news to you. :)
>
>

-- 
Jason Heinrich

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jan 13 2009 - 14:36:12 CST

Original text of this message