Re: View to see when index was made invisible

From: Mark Bobak <>
Date: Mon, 23 Dec 2013 18:49:33 +0000
Message-ID: <>

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.


PS Happy Holidays!/Merry Christmas!

From: Sandra Becker <<>> Reply-To: "<>" <<>> Date: Monday, December 23, 2013 at 12:27 PM To: oracle-l <<>> 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?


-- Received on Mon Dec 23 2013 - 19:49:33 CET

Original text of this message