Re: getting DDL for all indexes on a table (using dbms_metadata.get)

From: GS <>
Date: Wed, 21 May 2008 14:11:37 GMT
Message-ID: <t4WYj.3245$Yp.2173@edtnps92> wrote:
> On May 21, 6:10 am, GS <> wrote:

>> I have done
>> some research on dbms_metadata.get and see how I can generate ddl for a
>> specific table, but I want it to generate all the ddl for all indexes on
>> a given table, is this possible?

> "exp indexfile=", TOAD, and OEM will all do this without needing to
> write a single line of code.
> -- Phil

Curious, in OEM it's easy enough to get the DDL for a specific index, but not all indexes on a table. Unless I am looking in the wrong place? Received on Wed May 21 2008 - 09:11:37 CDT

Original text of this message