Compiling Invalid Objects....

[iyyappan]

Dear Gurus,

How to compile invalid objects in CTXSYS schema.

I have following objects are INVALID in CTXSYS schema.

SQL> select object_name,object_type,status,owner from dba_objects where status = 'INVALID'
2 and owner = 'CTXSYS';

OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE STATUS OWNER
------------------ ------- ------------------------------
CATINDEXMETHODS
TYPE BODY INVALID CTXSYS

TEXTINDEXMETHODS
TYPE BODY INVALID CTXSYS

When i compile invalid object i got the following error:

SQL> alter package CTXSYS.CATINDEXMETHODS compile body;
alter package CTXSYS.CATINDEXMETHODS compile body
*
ERROR at line 1:
ORA-04043: object CATINDEXMETHODS does not exist

How to solve the problem? can u please advise me,

Thanks in advance,
Iyyappan.M

[rohitsn]

Hi,
Run the script utlrp.sql to compile all the objects in the database.The script is found in $ORACLE_HOME/rdbms/admin/utlrp.sql

Regards,
ROhit Nirkhe,Oracle/Apps DBA,OCP 8i
oracle-support@indiatimes.com