Re: Extracting DDL from Oracle

There are some very usefull sql scripts on the net. I found one that creates a ddl for the table, indexes, constraints, grants etc. and can be used for a table reorg. It even compiles your stored procs related to the table. I will forward you a copy. Let me know if you don,t get it.

Steve Faull wrote in message <6foosg$4kr$1_at_usenet48.supernews.com>...
>Hello,
>
>I'm kinda new to Oracle DBA land and have what might be a basic question.
>Anyway, I was wonding if there's some sort of select statement or
 something
>that would extract DDL statements for objects stored in the given database.
>Spacifically, I want to extract all the DDL for all the indexes in a given
>tablespace. Is this even possible? Any help would be greatly appreciated.
>
>Thanks in advance,
>
>-Steve
>
>
Received on Wed Apr 01 1998 - 00:00:00 CST