-
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 .
-
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;".
-
?/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
-
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.
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|