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



Hi,

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

Thanks
Balaji
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: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
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.

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


Current Time: Mon Dec 23 10:50:20 CST 2024