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

Report message to a moderator

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.

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Sep 23 21:31:42 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.