Home » Other » General » recompiling objects
recompiling objects [message #538407] Thu, 05 January 2012 15:17 Go to next message
lynndba
Messages: 23
Registered: November 2011
Junior Member
Hi all i just did export and import of a schema into another database, i have some errors with some objects in other words they have to be recompiled.

What is the easiest way to go about. Pressed for time.

Thanks
Re: recompiling objects [message #538408 is a reply to message #538407] Thu, 05 January 2012 15:22 Go to previous messageGo to next message
joy_division
Messages: 4949
Registered: February 2005
Location: East Coast USA
Senior Member
If they are truly broken, you must go into each one and find out why.

Otherwise, if they are only INVALID because of objects not existing at the time of import, etc., you do not have to do anything as they will compile on their first execution.
Re: recompiling objects [message #538409 is a reply to message #538408] Thu, 05 January 2012 15:34 Go to previous messageGo to next message
lynndba
Messages: 23
Registered: November 2011
Junior Member
i don't think the are broken i get this error and on oracle docs it says it is a warning that the object needs to be recompiled. Import still in process i want to check dba_objects view after it is done thank you

ORA-39082: Object type PACKAGE_BODY:"string" created with compilation warnings
Re: recompiling objects [message #538414 is a reply to message #538408] Thu, 05 January 2012 19:54 Go to previous messageGo to next message
ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Quote:
they have to be recompiled.

What is the easiest way to go about. Pressed for time.




joy_division wrote on Fri, 06 January 2012 02:52
If they are truly broken, you must go into each one and find out why.

Otherwise, if they are only INVALID because of objects not existing at the time of import, etc., you do not have to do anything as they will compile on their first execution.


Its the perfect answer for you! Re read what he said.

Sriram
Re: recompiling objects [message #538445 is a reply to message #538409] Fri, 06 January 2012 01:34 Go to previous message
Michel Cadot
Messages: 67374
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can use utlrp.sql script or UTL_RECOMP package to recompile all objects and see if some are not recompilable.

Regards
Michel
Previous Topic: Export schema with FGAC
Next Topic: 32bit VS 64bit
Goto Forum:
  


Current Time: Thu Oct 01 02:51:22 CDT 2020