Home » RDBMS Server » Enterprise Manager » Recompile invalid objects
Recompile invalid objects [message #247034] Sat, 23 June 2007 00:53 Go to next message
webadministrator
Messages: 45
Registered: October 2005
Member
hello again

i imported my database on a new server and i have some invalid functions and procedures, is there a way to recompile them automatically or do i have to do it manually for each one?

Thank you
Re: Recompile invalid objects [message #247070 is a reply to message #247034] Sat, 23 June 2007 10:15 Go to previous messageGo to next message
krblr
Messages: 24
Registered: April 2007
Location: MD
Junior Member


SQL> @$?/rdbms/admin/utlrp will do it.

Although, I still don't know how to do it with this new EM 10gr2, but I can do this easily from Toad. Any experiences? please let us know also.

Thanks.
krblr
Re: Recompile invalid objects [message #247074 is a reply to message #247070] Sat, 23 June 2007 10:36 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And why not using this good old and never outdone SQL*Plus?

Regards
Michel
Re: Recompile invalid objects [message #247133 is a reply to message #247074] Sun, 24 June 2007 11:05 Go to previous messageGo to next message
krblr
Messages: 24
Registered: April 2007
Location: MD
Junior Member

No complaints about SQLPlus, most of us (dbas/developers) would go crazy without it, but here is why I think we should be able to do it from EM.
1) If you would want to address all administrative tasks from the Grid control.
2) Also, you might want to give partial control of certain databases to certain users via the grid only as a one stop shop.


Re: Recompile invalid objects [message #247136 is a reply to message #247133] Sun, 24 June 2007 11:25 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1) Good, but Grid Control does not allow to easily do such things as recompile all invalid procedures.

2) It's just a marketing ad. You can't give partial control over certain databases to certain users with Grid. You can do it with simple tools like SQL*Plus.
For instance, you have to grant your user at least SELECT_CATALOG_ROLE role just to be able to connect to Grid. Next, just to see the tablespaces, you have to grant him SELECT ANY DICTIONARY privilege.
Too bad for the security! ./fa/1686/0/

Regards
Michel

[Updated on: Sun, 24 June 2007 11:26]

Report message to a moderator

Previous Topic: Problem in configuring OMS
Next Topic: emclt error
Goto Forum:
  


Current Time: Mon Dec 05 15:19:17 CST 2016

Total time taken to generate the page: 0.05156 seconds