Re: Schema sql scripts

Uday Moogala wrote:
>
> 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

dbms_metadata

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."