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