Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: looking for schema re-engineering script

Re: looking for schema re-engineering script

From: Patrick Dewael <dewael.p_at_pg.com>
Date: 2000/07/14
Message-ID: <396ECB69.4313CCCE@pg.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US