Sorry I did not reply with the answer since I thought this message was dead! I was bit by Steve Adam's cr_xviews.sql scripts. This view was created while back when I ran that, so it wasn't an issue. I built a new database and nothing was invalid so that helped me figure it out! Thanks! On 5/18/07, M Rafiq <rafiq9857@xxxxxxxxxxx> wrote:
I could not find this object/view either of 10g databases (10.1 or 10.2.0.3) databases. Those are all newly created databases and no migration was involved. Regards Rafiq