Re: check all index efficiently

Limin Guo wrote:
>
> I need a fast way to know if all of my table indexes are still there
> and be able to get information as soon as the index is gone.
>
> Limin Guo
> DBA
> Andrews Universityselect * from dba_indexes where table_name = 'THE TABLE NAME';

-- 
Rich Woods, Field Support Analyst 
Oracle Corporation, USA
The comments and opinions expressed herein are mine and 
do not necessarily represent those of Oracle Corporation.