Oracle Database Discussions

Hello friends,

There is a problem with Invalid obejcts.

Plase find the brief abt problem
---------------------------------
I have imported the dump into database, It was completed with warnings.

Then after I could see the aroung 280 invalid objects , I execute the utlrp.sql to recompile the invalid objects , but still there are aroung 40 invalid sysman objects and 2 sys user's views and some other also..

I tyied to complile them by manually but I got warnings.
There are no invalid objects in source database ( From which I took export).

IN ONE ARTICAL I SAW THAT , IF WE EXECUTE THE catproc.sql script again it will complie all the invalid objects.

I executed that catproc.sql ..it was hung in middle of execution.

----------------------------
My doubt is... is there any problem by exectuting the catproc.sql after import has done ?

What is the best way to recompile the INVALID objects.

Please suggest me on this..

Thanks

Mahesh