Recompiling broken objects in Oracle

16 Feb

Recompiling broken objects in Oracle

Posted February 16, 2011 by vinayaknp in Oracle, Tech. Leave a Comment

Sometimes , changing procedures, functions etc breaks other objects in the datbase. To recompile all broken objects, run the following as SYSTEM user on the database

@?/rdbms/admin/utlrp.sql

Rate this:

Like this:

Be the first to like this post.

Leave a Reply Cancel reply

Enter your comment here...

Fill in your details below or click an icon to log in:

Email (required) (Address never made public)

Name (required)

Website

You are commenting using your WordPress.com account. ( Log Out / Change )

You are commenting using your Twitter account. ( Log Out / Change )

You are commenting using your Facebook account. ( Log Out / Change )

Cancel

Connecting to %s

Technorama Technical Info I come across in my work… Hopefully they will be of use sometime