Re: how to create DDL from existing DB

From: Owais Anjum <owais_anjum_at_my-deja.com>
Date: Wed, 05 Jan 2000 10:41:31 GMT
Message-ID: <84v74q$kae$1@nnrp1.deja.com>

In article <84uove$9pq$1_at_nnrp1.deja.com>,   M. Armaghan Saqib <armaghan_at_yahoo.com> wrote:
> My freeware tool SQLPlusPlus gives you commands to extract DDL into a
> text file.
>
> For example to get DDL for all tables in SCOTT, you execute
>
> EXEC s.GETTAB('%','SCOTT')
>
> in SQL Plus
>
> Download it free.
>
> regards,
> M. Armaghan Saqib
>

---

> * SQL PlusPlus : Add power to SQL Plus command line
> * SQL Link for XL : Integrate Oracle with XL
> * Oracle CBT with sample GL (Triggers and Forms Source Code included.
> Download free: http://www.geocities.com/armaghan/
>

---

> ajeru <ajeru_at_my-deja.com> wrote in message news:84t9r6
> $buh$1_at_nnrp1.deja.com...
> > 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.
>

You can use a data modeling case tool to do the job. e.g. ERwin would allow you to reverse engineer an existing database and from there, you can generate the required script.

I'm sure some other data modeling tools would also have a similar feature.

--
Owais Anjum

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Jan 05 2000 - 04:41:31 CST