Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Insufficient privs on dbms_utility.compile_schema

Re: Insufficient privs on dbms_utility.compile_schema

From: Dave <x_at_x.com>
Date: Thu, 02 Dec 2004 20:51:41 GMT
Message-ID: <xfLrd.28677$up1.12297@text.news.blueyonder.co.uk>

"DanO" <daniel.ostertag_at_visaer.com> wrote in message news:6e07b2d5.0412021234.69572204_at_posting.google.com...
>I am running the compile_schema utility in 10g the exact same way I
> ran it in 9i, 8i, etc. (i.e. exec dbms_utility.compile_schema('XXX); )
> and now I am getting the following error:
>
> ERROR at line 1:
> ORA-20000: You have insufficient privileges for an object in this
> schema.
> ORA-06512: at "SYS.DBMS_UTILITY", line 422
> ORA-06512: at line 1
>
> I am logging on as the same user whose objects I'm trying to compile
> but have these priv problems. I ran a trace with errorstack level 10
> and looked at the trace file. The error told me that I had no privs to
> compile VISIB."BIN$O9IO/EHVSSQ0LNWQXSUKNG==$0. This is a recycle table
> trigger and I don't care about it, yet it's preventing me from
> compiling all.
>
> How do you get around this in 10g? I've purged my recyclebin and this
> didn't fix the problem. I just want to compile my known objects, not
> any hidden BIN$ stuff.
>
> Thanks,
> Dan

run it as sys Received on Thu Dec 02 2004 - 14:51:41 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US