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

From: GS <GS_at_GS.com>
Date: Wed, 21 May 2008 14:11:37 GMT
Message-ID: <t4WYj.3245$Yp.2173@edtnps92>

phil_herring_at_yahoo.com.au wrote:
> On May 21, 6:10 am, GS <G..._at_GS.com> 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