Home » RDBMS Server » Server Utilities » Objects gets invalid during import (Oracle 10g,, Unix)
Objects gets invalid during import [message #492607] Tue, 01 February 2011 06:56 Go to next message
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member


Why is that we recompile all invalid objects after import and how the object gets invalid during import?

Re: Objects gets invalid during import [message #492610 is a reply to message #492607] Tue, 01 February 2011 07:29 Go to previous message
Michel Cadot
Messages: 68500
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you recreate some procedure, package or view during an import then depending objects are invalidated and needs recompîlation to revalidate them.

Previous Topic: Statspack report in windows and linux
Next Topic: Can hot backup called as logical backup
Goto Forum:

Current Time: Sat Sep 23 21:31:42 CDT 2023