RE: Script to reverse engineer all objects in a schema to DDL?

From: Suhen Pather <Suhen.Pather_at_strandbags.com.au>
Date: Mon, 02 Apr 2001 21:58:26 -0700
Message-ID: <F001.002DF321.20010402211558@fatcity.com>

Chris,

You could use a program such as TOAD which is available for download that can
extract DDL statements.
There are other programs such as SQL Navigator, DB Artisan, EZSQL are available but requires
you to purchase a copy.

Otherwise use export and import with indexfile or show=y options. This would give you the DDL statements for the exported objects.

HTH
Suhen

Hi,

I need a script to reverse engineer all objects in a schema to DDL statements. I think I've seen something on the web, but I cannot find it now, can anyone help me?

thankyou,
Chris Borrill
Analyst/Programmer

Application Development Centre
Compaq Computer New Zealand

Phone: 64 3 371 5769

Fax:            64 3 371 5747
E-mail:     Chris.Borrill_at_Compaq.com

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Borrill, Chris
INET: Chris.Borrill_at_compaq.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Suhen Pather
INET: Suhen.Pather_at_strandbags.com.au

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------