Re: ORA-1031 when privileges have been granted

  • From: Jason Heinrich <jheinrichdba@xxxxxxxxx>
  • To: Jared Still <jkstill@xxxxxxxxx>
  • Date: Tue, 13 Jan 2009 14:36:12 -0600

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@xxxxxxxxx> wrote:

>
> On Fri, Jan 9, 2009 at 8:19 AM, Jason Heinrich <jheinrichdba@xxxxxxxxx>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

Other related posts: