Re: getting DDL for all indexes on a table (using dbms_metadata.get)
From: <phil_herring_at_yahoo.com.au>
Date: Tue, 20 May 2008 16:45:57 -0700 (PDT)
Message-ID: <319480c9-2b7a-40c3-826a-3ff783f6802e@x19g2000prg.googlegroups.com>
Date: Tue, 20 May 2008 16:45:57 -0700 (PDT)
Message-ID: <319480c9-2b7a-40c3-826a-3ff783f6802e@x19g2000prg.googlegroups.com>
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