Home » RDBMS Server » Server Administration » Better Approach For Recmpile the Object (oracle version 10g Windows XP)
Better Approach For Recmpile the Object [message #519311] Thu, 11 August 2011 00:58 Go to next message
muktha_22
Messages: 527
Registered: December 2009
Senior Member
Hello All,

Need a advice on better approach for Recompile the INVALID object.

Kindly tell me the difference and the scenario to use below of the Methods.

A) dbms_ddl
B) dbms_utility
C) utl_recomp


Thanks and Regards
Muktha

Report message to a moderator

Re: Better Approach For Recmpile the Object [message #519316 is a reply to message #519311] Thu, 11 August 2011 01:21 Go to previous message
Michel Cadot
Messages: 68758
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Do nothing and let Oracle recompile when it needs it.

Regards
Michel

Report message to a moderator

Previous Topic: change tablespace of a table using dbms_redefinition
Next Topic: Dbms_Metadata issue
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jun 03 17:33:19 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.