Re: how to create DDL from existing DB

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 04 Jan 2000 19:03:46 +0800
Message-ID: <3871D392.F77@yahoo.com>

ajeru 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.

Such scripts exist on technet.oracle.com, or alternatively use TOAD from www.toadsoft.com, or use "exp full=y rows=n".

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Tue Jan 04 2000 - 05:03:46 CST