how to make db object invalid
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: how to make db object invalid

Hybrid View

  1. #1
    Join Date
    May 2002
    Location
    USA
    Posts
    462

    how to make db object invalid

    Hi Friends ,

    i am migrating database from 8.1.6 to 8.1.7
    we already have some invalid objects in database ..

    after migrating when we run utlrp.sql it will make all the objects invalid .

    how can i make initial invalid objects status invalid even after migration ...

    Thanks for your tips .

  2. #2
    Join Date
    Oct 2002
    Posts
    807
    You could spool objects that were invalid before the migration. Then go about attempting to make them invalid after the migration. But again, many of these objects will automatically recompile when accessed. With triggers, you can affect the outcome with a "alter trigger blah disable;".

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    ?/rdbms/admin/utlrp.sql - compiles all packages
    ?/rdbms/admin/utlip.sql - makes everything invalid
    Last edited by marist89; 08-24-2004 at 08:00 PM.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  4. #4
    Join Date
    Oct 2002
    Posts
    807
    Originally posted by marist89
    ?/rdbms/admin/utlrp.sql - compiles all packages
    ?/rdbms/admin/utlirp.sql - makes everything invalid
    Yeah, I'm guessing that he was concerned about invalid triggers essentially. The utlrp would then forcibly make it valid afterwards, even if someone had explicitly had them down as "invalid" before.

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by Axr2
    Yeah, I'm guessing that he was concerned about invalid triggers essentially. The utlrp would then forcibly make it valid afterwards, even if someone had explicitly had them down as "invalid" before.
    If they can be valid. There might be a case where the upgrade is causing packages to not be valid.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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