Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: looking for schema re-engineering script
Okay, stupid question time. Have you considered Export? It does what you are asking for. It can also product an editable setof 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
![]() |
![]() |