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

Home -> Community -> Usenet -> c.d.o.server -> looking for schema re-engineering script

looking for schema re-engineering script

From: Patrick Dewael <dewael.p_at_pg.com>
Date: 2000/07/14
Message-ID: <396ED757.24F2E778@pg.com>#1/1

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 ?
(export/import indexfile is not sufficient because it only generates the table and index definition into a script)

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