Q
Manage Learn to apply best practices and optimize your operations.

How to avoid invalid objects in Oracle when restoring the database

Learn how to avoid invalid objects in Oracle when restoring an Oracle database with either a full restore or partial restore in this expert tip.

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

Dig Deeper on Oracle database backup and recovery

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close