SYS/SYSTEM Objects
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: SYS/SYSTEM Objects

  1. #1
    Join Date
    Aug 2001
    Posts
    390
    what happened if I have some of the objects belonging to SYS/SYSTEM and they are invalid ???

    Please give me some advises of how to fix those invalid objects and give me some explanationsof the cause and effect if those objects are invalid.

    thanks

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Run utlrp.sql from $ORACLE_HOME/rdbms/admin If they ever get recalled, they would be compiled at the time of calling those packages. Else you can run the above mentioned script to compile them. This status was because that you ran the cat*.sql scripts or you did an upgrade.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Aug 2001
    Posts
    390
    Sam,

    Thanks for your email, could you please tell me what happened if there are some system objects are invalid ??? Would it harm the database by any reason ???

    Thanks for your help as always.


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