You might want to look at Datamodeling tools like Powerdesigner, Erwin.
http://www.sybase.com/products/powerdesigner/
--
Terry Dykstra (TeamSybase)
Canadian Forest Oil Ltd.
Sybase Developer's Network: http://www.sybase.com/sdn
Techwave 2000: http://www.sybase.com/techwave2000/
"Patrick Dewael" <dewael.p_at_pg.com> wrote in message
news:396ED757.24F2E778_at_pg.com...
> 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
