Go to the FreeLists Home Page Home Signup Help Login
 



[oracle-l] || [Date Prev] [09-2005 Date Index] [Date Next] || [Thread Prev] [09-2005 Thread Index] [Thread Next]

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

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




[ Home | Signup | Help | Login | Archives | Lists ]

All trademarks and copyrights within the FreeLists archives are owned by their respective owners.
Everything else ©2007 Avenir Technologies, LLC.