dumping out indexes
From: Vissu <Vissuyk_at_yahoo.com>
Date: 30 May 2002 19:17:59 -0700
Message-ID: <16b21687.0205301817.14648e41_at_posting.google.com>
Date: 30 May 2002 19:17:59 -0700
Message-ID: <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