Re: View to see when index was made invisible

From: Mark Bobak <Mark.Bobak_at_proquest.com>
Date: Mon, 23 Dec 2013 18:49:33 +0000
Message-ID: <CEDDEF78.3CCA7%Mark.Bobak_at_ProQuest.com>

Unless you had auditing enabled *before* the index was made invisible, I think not.

A quick look at DBA_INDEXES definition, and you can see that the visibility status of an index is just a bit in the FLAGS column of IND$. I can't imagine that Oracle records date/time that it flipped a bit.

-Mark

PS Happy Holidays!/Merry Christmas!

From: Sandra Becker <sbecker6925_at_gmail.com<mailto:sbecker6925_at_gmail.com>> Reply-To: "sbecker6925_at_gmail.com<mailto:sbecker6925_at_gmail.com>" <sbecker6925_at_gmail.com<mailto:sbecker6925_at_gmail.com>> Date: Monday, December 23, 2013 at 12:27 PM To: oracle-l <oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>> Subject: View to see when index was made invisible

Running 11gr3 EE. Is there a view where I can see when an index was made invisible?

--

Sandy
GHX
--

http://www.freelists.org/webpage/oracle-l Received on Mon Dec 23 2013 - 19:49:33 CET