OraFAQ Forum: General » recompiling objects

Home » Other » General » recompiling objects

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

recompiling objects [message #538407]

Thu, 05 January 2012 15:17

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

Report message to a moderator

Re: recompiling objects [message #538408 is a reply to message #538407]

Thu, 05 January 2012 15:22

joy_division
Messages: 4963
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.

Report message to a moderator

Re: recompiling objects [message #538409 is a reply to message #538408]

Thu, 05 January 2012 15:34

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

Report message to a moderator

Re: recompiling objects [message #538414 is a reply to message #538408]

Thu, 05 January 2012 19:54

ramoradba
Messages: 2456
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

Report message to a moderator

Re: recompiling objects [message #538445 is a reply to message #538409]

Fri, 06 January 2012 01:34

Michel Cadot
Messages: 68641
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

Report message to a moderator

Previous Topic:	Export schema with FGAC
Next Topic:	32bit VS 64bit

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 07:51:31 CDT 2024