Re: getting DDL for all indexes on a table (using dbms_metadata.get)
Date: Tue, 20 May 2008 16:45:57 -0700 (PDT)
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.