Re: Schema sql scripts

From: <davide_at_yahoo.com>
Date: 16 Apr 2002 09:19:13 GMT
Message-ID: <a9gqah$31pru$4@ID-18487.news.dfncis.de>

Yaron Avior <yavior_at_mercury.co.il> wrote:
> Is there a way I can automatically generate from a schema SQL script
> that running it will create the same schema (not including the data -
> only the schema objects including indexes, foreign keys, sequences
> etc.)?

There are some tools (TOAD for example) that can reverse-engineer the database. I didn't have a lot of luck with them anyway...

If you can find it there is a collection of SQL scripts called FOT (Famous Oracle Toolbox) that can perform similar things.

Davide Received on Tue Apr 16 2002 - 04:19:13 CDT