Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> 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. Can
> 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 Fri Jul 14 2000 - 00:00:00 CDT
![]() |
![]() |