Re: Schema sql scripts

From: Uday Moogala <umoogala_at_oracle.com>
Date: Tue, 16 Apr 2002 09:45:08 -0400
Message-ID: <3CBC2AE4.61F0C270@oracle.com>

I think Oracle9i has a package to do this, I don't remeber the package name.

davide_at_yahoo.com wrote:

> 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 - 08:45:08 CDT