Compare user Objects Feature request

[Roeland]

Hi,

Could the target database automatically (or by asking) compile the invalid objects?

Now I have to login into the target db and do the recompile.
It would be a little easier to do it from within the compare window.

Roeland

 

[Marco Kalter]

Nice idea. I have added this to the list of enhancement requests.

 

[matjazc]

check utlrp.sql script (run it in SQL*Plus):

@?/rdbms/admin/utlrp.sql

It comes installed with database or administrator Oracle client

You could alse create a db job that does it.

 

[matjazc]

See this for some other solutions:
http://www.oracle-base.com/articles/misc/RecompilingInvalidSchemaObjects.php