Re: looking for schema re-engineering script

        I have seen a script that does what you want, but I am not sure where it was.
Try Oracle's Federal Systems download site.

>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 7/14/00, 3:12:25 AM, Patrick Dewael <dewael.p_at_pg.com> wrote regarding  

Re: looking for schema re-engineering script:

> Thanks for your quick response !
 

> Oke,
 

> but creating the indexfile (if this what you're referring to) only
 re-engineers
> the table and index definition. I've used it many times to recalibrate
 

erroneous
> storage parameters. However constraints, grants, synonyms, stored
 procedures,
> views, user quota, etc. are not included into this file. That's why I

would like
> to have a general script to produce an editable DDL, preferably on
schema level.

> Regards,
 

> Patrick
 

> Jerry Gitomer wrote:
 

> > Okay, stupid question time. Have you considered Export?
> > It does what you are asking for. It can also product an
 editable set
> > of DDL statements.
> >
> > Original Message dated 7/13/00, 10:16:51 AM
> > Author: Patrick Dewael <dewael.p_at_pg.com>
> > Re: looking for schema re-engineering script:
> >
> > Hi,
> > I'm currently looking for a script that catches/re-engineers
> > generically all (or nearly all) objects from a certain schema for an
 

> > Oracle 8i environment. It has to include the LOB storage settings. C
 an
> > anyone help me ?
> > The objects necessary to be covered:
> > CREATE USER statement
> > tables + storage parameters
> > indexes + storage parameters
> > views
> > triggers
> > constraints
> > grants
> > packages/procedures and function
> > synonyms
> > Thanks,
> > Patrick
> >
Received on Sat Jul 15 2000 - 00:00:00 CDT