Re: View to see when index was made invisible
- From: Don Seiler <don@xxxxxxxxx>
- To: Mark Bobak <Mark.Bobak@xxxxxxxxxxxx>
- Date: Mon, 23 Dec 2013 13:57:36 -0600
Perhaps the last_ddl_time of the index in dba_objects would possibly
indicate? This is assuming that the ALTER INDEX to make it invisible was
the last DDL on it. I haven't tested this though.
On Mon, Dec 23, 2013 at 12:49 PM, Mark Bobak <Mark.Bobak@xxxxxxxxxxxx>wrote:
> 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@xxxxxxxxx>
> Reply-To: "sbecker6925@xxxxxxxxx" <sbecker6925@xxxxxxxxx>
> Date: Monday, December 23, 2013 at 12:27 PM
> To: oracle-l <oracle-l@xxxxxxxxxxxxx>
> 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
>
--
Don Seiler
http://www.seiler.us
Other related posts:
