Re: Reverse engeneering : a way to get the DB shema

Sebastien,

[Quoted]    You can download Toad from Quest, they have a free version (at least good for one
[Quoted] month) . It can generate DDL from your schema. It does exactly what you want [Quoted] and probably more.

"Tom Grenier" <tom_at_sqlman.com> wrote in message news:3AD20302.38510D42_at_sqlman.com...
> Sebastien,
>
> This was one of my largest frustrations with Oracle (I am switching to
> Oracle but have primarily been an Informix person). Informix does this
> with the dbschema command -- it creates an actual DDL script, but I use it
> primarily as a DESCRIBE as I like to work with a paper description of the
> database (with more detail than DESCRIBE gives).
>
> Anyway, I wrote a small procedure in PL/SQL to do this. It DOES NOT
 create
> an executable .sql file -- if this is what you need it won't do it.
> However, if you want a schema of the database that gives constraints,
> indexes etc. it may to the trick.
>
> If you have any interest in it you can download it from my web site --
> www.sqlman.com -- first item on the SQL Puzzles page. No guarantees that
> it works as it should -- I've tested on 8i on NT (appears to work fine)
 and
> 7 on Solaris (misses a lot of the constraints but otherwise seems to work
> fine).
>
> Or feel free to use it as a starting point for what you need.
>
> Tom
>
> Sebastien Le Floc'h wrote:
>
> > Hi, I've got a db on oracle 8.i and we're looking for a soft that could
> > connect the db and do the DB shema (merise....)
> > Any idea welcome
> > Thanks a lot
>
Received on Wed Apr 11 2001 - 13:51:09 CEST