RE: dba_hist views going invalid
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: <barb.baker@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 12 May 2005 16:17:49 -0400
If you query the view do they automatically revalidate correctly? There
was a patch that stopped the views from showing as invalid in OEM though
naturally the views do still become invalid.
-- Mark D Powell --
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Barbara Baker
Sent: Thursday, May 12, 2005 1:31 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: dba_hist views going invalid
Oracle 10.1.0.3
Solaris 5.9
Several of my dba_hist views go invalid every night. I see a discussion
of this on metalink, but no solution. (Both Mark Powell and John
Kanagaraj contributed to the discussion on Metalink.)
Does anyone know what the resolution is?
Thanks for any help.
Barb
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
