Skip to content

Recompiling Invalid Schema Objects

Operations such as upgrades, patches and DDL changes can invalidate schema objects. Provided these changes don’t cause compilation failures the objects will be revalidated by on-demand automatic recompilation, but this can take an unacceptable time to complete, especially where complex dependencies are present. For this reason it makes sense to recompile invalid objects in advance of user calls. It also allows you to identify if any changes have broken your code base. This article presents several methods for recompiling invalid schema objects.

Posted from : https://oracle-base.com/articles/misc/recompiling-invalid-schema-objects

More links : https://copyprogramming.com/howto/dbms-utility-compile-schema-in-procedure#google_vignette

Link : https://engineering.peerislands.io/oracle-schema-analysis-b2b2c0460df3

Link: http://www.dbarepublic.com/2014/07/compiling-invalid-objects.html

Link: https://decipherinfosys.wordpress.com/2009/02/06/back-to-the-basics-compiling-schema-objects-using-dbms_utility-package/

Link: https://techgoeasy.com/invalid-object-compilation-steps/?utm_content=cmp-true

Tags:

Leave a Reply

Your email address will not be published. Required fields are marked *

Exit mobile version