Re: how to create DDL from existing DB

From: Gavinator <Gavinator_nospam_at_home.com>
Date: Tue, 04 Jan 2000 19:19:16 GMT
Message-ID: <3872476e.11085279@news.videon.wave.ca>

Oracle Designer does a good job of reverse engineering the db and you could then create the scripts from it, plus a lot more.

On Tue, 04 Jan 2000 17:15:32 GMT, ajeru <ajeru_at_my-deja.com> wrote:

>Hi,
>
>Does anyone have an idea how I can generate all the DDL statements
>necessary to recreate an existing oracle database. It's not only a
>backup problem. I need the SQL statements for documentation reasons
>among other things. And the resulting create table statements should
>include all the alter table statements made since the database was first
>created.
>
>Thanks
>
>--
>Alexander Jerusalem
>Vienna Knowledge Net
>alexander.jerusalem_at_Xchello.at
>To mail me remove the X before chello
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Tue Jan 04 2000 - 13:19:16 CST