X_$ Views

  • From: LeRoy Kemnitz <lkemnitz@xxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 01 Sep 2005 09:48:56 -0500

All-

I am running 9.2.0.5 on AIX 5.3 currently. I plan to upgrade to 10.1.0.2 but having some concerns. I was wondering if others have heard of this or experienced it. I queried the existing DB to see the list of INVALID objects and found several V_$ views are INVALID. They are owned by SYS. I Googled on these and found that in some places people said that the views are not necessary and they will be recreated when I upgrade. I logged a TAR yesterday and they haven't responded yet. I tried to upgrade to 10g two weeks ago with this DB but it failed cuz if invalid SYS views.

Are these views needed? Are they created by outside vendor code? Anyone know any more?

LeRoy

--
//www.freelists.org/webpage/oracle-l

Other related posts: