Re: Reconstruct CREATE <objtype> Statements from existing DB

"Wolfgang Fiedler" <fiedler_at_sbox.TUGraz.at> wrote in message news:3D3BBF81.44772C05_at_sbox.TUGraz.at...
> Hello,
>
> I have a Oracle 8i (8.1.6) Database running on Linux since
> nearly 2 years. During that time the database layout was
> modified very often (all column, delete column, add a lot
> of tables, add/mod/delete views|triggers|constraints,...)
>
> Now I have a small set of initial CREATE stmts and countless
> ALTER ... and CREATE ... statements for the modifications.
>
> Q:
> Is there a way to reconstruct a set of CREATE <objecttype>
> statements from this existing database?
> (For views and triggers this is quite easy, but for tables
> and constraints??) (A free Tool working on Unix is preferred)
>
> TIA
> wolfgang
> --
> ***********************************************************************
> Wolfgang Fiedler http://fiedler.vc-graz.ac.at fiedler_at_sbox.tugraz.at
> Student of Telematics at Graz University of Technology, Austria, Europe

Your tool is called exp. Use it with rows=n and you have the schema in a dump file. Run imp show=y log=<any filename> and you have the schema in ascii format. Do NOT vi the dmp

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address