Please check out www.oriolecorp.com, download idxaudit.sql
Joan
ORACLE-L_at_fatcity.com wrote:
>
> SUBJECT too long. Original SUBJECT is
> How to find index is used or not, before dropping it. Please resp
>
> ---------------------- Original Message Follows ----------------------
>
> Hi Oracle Gurus,
> Is there a way to find once created index is used or not?
> I mean if I want to drop a index , is there any way to find out whether that
> has been in use since a particular time?
> Thanks
> -Sandesh
> --
> Author: Naik, Sandesh
> INET: Sandesh.Naik_at_compaq.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Mon Aug 14 2000 - 14:32:44 CDT
