Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

Susan YangMar 25 2009 — edited Mar 25 2009

Hello,

I was trying to recompile the invalid objects on a schema level by using the dbms_utility.compile_schema, but encountered some issue. Please see below:

SQL> exec dbms_utility.compile_schema('SCTCVT');
BEGIN dbms_utility.compile_schema('SCTCVT'); 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

Can someone help to explain why this happens?

Thanks!

Edited by: user10454776 on Mar 25, 2009 11:11 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 22 2009

Added on Mar 25 2009

#general-database-discussions

2 comments

3,145 views