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.
Received on Wed Jan 05 2000 - 00:39:44 CST