Re: ORA-1031 when privileges have been granted
Date: Tue, 13 Jan 2009 14:36:12 -0600
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