how to make db object invalid

[prakashs43]

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 .

[Axr2]

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;".

[marist89]

?/rdbms/admin/utlrp.sql - compiles all packages
?/rdbms/admin/utlip.sql - makes everything invalid

[Axr2]

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.

[marist89]

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.