Tuesday, June 4, 2013

Invalid Object Compilation

I was working on application, and every time when I release some new versions in UAT or Production, I have to compile all the invalid objects one by one.

I google for the command to compile all the invalid objects in one go. After spending quite good time on google, I found out this


exec sys.utl_recomp.recomp_serial();


Hope, this will be useful to some and save their time of searching.

No comments:

Post a Comment