Invalid objects
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Invalid objects

  1. #1
    Join Date
    May 2002
    Posts
    193

    Invalid objects

    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
    Attached Files Attached Files

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    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
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  3. #3
    Join Date
    May 2002
    Posts
    193
    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

  4. #4
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    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
    I'm stmontgo and I approve of this message

  5. #5
    Join Date
    May 2002
    Posts
    193
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width