Re: looking for schema re-engineering script

In article <396ED757.24F2E778_at_pg.com>,
  Patrick Dewael <dewael.p_at_pg.com> wrote:
> 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
>
>

Instead of the indexfile=y parameter use the show=y parameter; you get everything in the export file including the tables and indexes; indexfile was meant for just that purpose, to allow indexes to be migrated and/or relocated to a different tablespace.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com http://www.deja.com/
Before you buy.