Re: Extracting DDL from Oracle

>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

Another possibility:
If you already have an export dump file, Import's 'INDEXFILE=foo.sql' parameter will write the DDL for all tables and indexes in the selected dump file to foo.sql. This can be combined with the INDEXES=N parameter to defer index creation at import time.

• George Claborn (Oracle VLDB dev.)