Ask The Oracle Expert: Questions & Answers

How to avoid invalid objects in Oracle when restoring the database

How to avoid invalid objects in Oracle when restoring the database

By  Brian Peasland, Database Administrator, SGT, Inc.

SearchOracle.com

Why is it that when I restore my Oracledatabase, some of the function/procedures are invalid objects?
If you performed a full restore, then you should not have invalid objects in Oracle. When you do a partial restore, you may be dropping tables (during

To continue reading for free, register below or login

Requires Membership to View

To gain access to this and all member only content, please provide the following information:

By joining SearchOracle.com you agree to receive email updates from the TechTarget network of sites, including updates on new content, magazine or event notifications, new site launches and market research surveys. Please verify all information and selections above. You may unsubscribe at any time from one or more of the services you have selected by editing your profile or unsubscribing via email.

TechTarget cares about your privacy. Read our Privacy Policy

the restore operation) that are needed by the function or procedure. The object that depended on this table is then made invalid. Once the table is restored, the object does not become valid until you recompile it, or someone accesses the object and Oracle recompiles it for you.