Invalid objects

[diwakar]

Dear All,

I would like to see a solution from you regarding the problem that Iam facing. I tried to recompile the objects in one of my databases. Also after this and executing the package utlrp.sql, I still have the following package body of user SYS invalid:

DBMS_ASYNCRPC_PUSH
DBMS_DEFER_INTERNAL_SYS
DBMS_DEFER_SYS_PART1
DBMS_IAS_MT_INST
DBMS_REPCAT_MIG_INTERNAL
DBMS_REPCAT_RGT


Could anybody throuw light on how to make them valid??

The accompanying errors during compilation are attached

Regards,

K.Diwakar

[jovery]

Those objects are replication objects, did you install advanced replication? If you want to get rid of them you can run $ORACLE_HOME/rdbms/admin/catrepr.sql as SYS.

If you don't want to deinstall replication you shoule rerun catrep.sql.

Regards

[diwakar]

Dear Jovery,

Thank you for your valuable suggestion Mr.Jovery. Could you please add on as to how to get a list of objects used for Replication??

Regards,

K.Diwakar

[stmontgo]

Originally posted by jovery
Those objects are replication objects, did you install advanced replication? If you want to get rid of them you can run $ORACLE_HOME/rdbms/admin/catrepr.sql as SYS.

If you don't want to deinstall replication you shoule rerun catrep.sql.

Regards

don't forget to run catproc as sys after catrepr as catrepr whacks
some objects that will need to be recreated by catproc

steve

[diwakar]

Dear All

Thank you for your suggestions and things have really worked. But like on what basis you come to a conclusion that these are replication objects??

Regards,

K.Diwakar