This content has been marked as final. Show 3 replies
some times back I received the same message and after a great deal of R&D I landedup with the following solution..
Thanks for your update.
Did not had a chance to check your solution ..as i got it worked out.
1) Running utlirp.sql (this is going to invalidate most (for me around 80,000 objects) and then recompiles them again) Took a helluva time.. but got it sorted out. in the end.
2) Had to run utlirp.sql when database is in migration mode. (remember I ported the db from 32 bit to 64 bit).
I am sure that this "IS A" solutions as now, I am getting the same error with 32bit version of oracle software. However with 64 bit I am fine. now. before this the error was with 64 bit and 32 bit was clean.
Party TIME. ;-)
Thanks for your help Anirban .. next time .. I will try your idea first.