Re: Extracting DDL from Oracle

Hi,

 You may try using EXPORT/IMPORT Oracle Utilities to get the scripts. This is one of the easiest method without having to worry about writing sqlscripts from oracle data dictionary.

----Details as follows----

The EXPORT FILE contains all of the CREATE statements required to recreate all of the database objects that were exported. This is useful for further analysis and for documentation.

By using the INDEXFILE keyword, the CREATE INDEX statements can be written to a separate file.

The file specified by INDEXFILE parameter contains all of the create INDEX statements that appear in the EXPORT FILE itself, including the storage parameter. We can use this file later to create index.

Good luck,

Manoj Jain

In article <6foosg$4kr$1_at_usenet48.supernews.com>,   "Steve Faull" <stevef_at_photodisc.com> wrote:
>
> 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
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon Mar 30 1998 - 00:00:00 CST