| Recompile invalid objects [message #247034] |
Sat, 23 June 2007 00:53  |
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  |
|
|
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 #247133 is a reply to message #247074] |
Sun, 24 June 2007 11:05 |
|
|
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 |
 |
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
|
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! 
Regards
Michel
[Updated on: Sun, 24 June 2007 11:26] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
