ORA-24237: object id argument passed to DBMS_UTILITY.INVALIDATE is not legal

Admin — Fri, 08 Jan 2010 18:56:38 GMT

I wanted to compile schema as sys and was getting this error . Couldn't figure it out and then finally i did after some research.

SQL> conn / as sysdba

Connected.

SQL> exec dbms_utility.compile_schema('SERVICEACCT');

BEGIN dbms_utility.compile_schema('SERVICEACCT'); END;

ERROR at line 1:

ORA-20000:

ORA-06512: at "SYS.DBMS_UTILITY", line 347

ORA-24237: object id argument passed to DBMS_UTILITY.INVALIDATE is not legal

ORA-06512: at line 1

Cause

SYS does not have the required privileges to run the procedure.

Solution

To check whether SYS has the required privileges, run the following query connected as SYS:

SQL> select username, privilege from user_sys_privs order by privilege;

If SYS does not have the following privileges, then grant them to SYS directly:

CREATE ANY DIMENSION
CREATE ANY EVALUATION CONTEXT
CREATE ANY INDEX
CREATE ANY INDEXTYPE
CREATE ANY LIBRARY
CREATE ANY MATERIALIZED VIEW
CREATE ANY OPERATOR
CREATE ANY PROCEDURE
CREATE ANY RULE
CREATE ANY RULE SET
CREATE ANY SYNONYM
CREATE ANY TRIGGER
CREATE ANY TYPE
CREATE ANY VIEW

hope this helps

FranklinFaces.com - Oracle & SQL Server Database Forums for all IT Professionals / Oracle Forum / ORA - Oracle Database Error Codes - Search via specific error codes. / ORA-20000 Through ORA-29968 / ORA-24237: object id argument passed to DBMS_UTILITY.INVALIDATE is not legal / Latest Posts

ORA-24237: object id argument passed to DBMS_UTILITY.INVALIDATE is not legal

Cause

Solution