Re: dumping out indexes

Vissuyk_at_yahoo.com (Vissu) wrote in message news:<16b21687.0205301817.14648e41_at_posting.google.com>...
> Hi,
>
> We do not have documentation of all indexes in our database. We have
> some concatenated indexes too. How can I dump all the indexes in the
> system to a file ? I can query the dba_indexes but it wont tell me the
> order of columns (in case of multi column index). I know we can dump
> tables to trace file, is there a similar trick for dumping out all
> indexes ?
>
> Thanks very much
>
> Vissu

what does select * from dict where table_name like '%IND%' tell you? The info you need is in dba_ind_columns!

Hth

Sybrand Bakker
Senior Oracle DBA Received on Fri May 31 2002 - 11:48:30 CEST