Re: View to see when index was made invisible

From: Don Seiler <don_at_seiler.us>
Date: Mon, 23 Dec 2013 13:57:36 -0600
Message-ID: <CAHJZqBAkSTGXL6ihyxPQULGBE68CpE-HsF1QNkwaLH0Fo=f+Zw_at_mail.gmail.com>

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_at_proquest.com>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_at_gmail.com>
> Reply-To: "sbecker6925_at_gmail.com" <sbecker6925_at_gmail.com>
> Date: Monday, December 23, 2013 at 12:27 PM
> To: oracle-l <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
>

-- 
Don Seiler
http://www.seiler.us

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

Received on Mon Dec 23 2013 - 20:57:36 CET