Re: check all index efficiently

Use the following select to check if your index is still present

select * from user_indexes
where table_name = 'XXX';
(Where XXX is the table in question)

Sanjay Mathew
Oracle DataBase Administrator
U.K

Limin Guo <guo_at_andrews.edu> wrote in article <%rTFnyoAH-_at_olive>...
>
> 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 University
>
>
  Received on Wed Nov 27 1996 - 00:00:00 CET