ORA-2000,ORA-06512,ORA-06512: Object Compilation Error.
710514Jul 13 2009 — edited Jul 13 2009Hi all,
I am facing the following problem while compiling the objects of user a particular schema(USER1).Can anybody help me to sort out this problem:
SQL> conn sys as sysdba
Enter password:
Connected.
SQL> EXEC DBMS_UTILITY.compile_schema(schema => 'USER1');
BEGIN DBMS_UTILITY.compile_schema(schema => 'USER1'); END;
*
ERROR at line 1:
ORA-20000: You have insufficient privileges for an object in this schema.
ORA-06512: at "SYS.DBMS_UTILITY", line 411
ORA-06512: at line 1
Thanks,
Abhijeet Tiwari
Oracle DBA