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.
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-lReceived on Tue Jan 13 2009 - 14:36:12 CST