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: Jerry Gitomer <jgitomer_at_erols.com>
Date: 2000/07/14
Message-ID: <20000714.5213000@p200.nodomain>#1/1

	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