Re: looking for schema re-engineering script

Patrick,

(Always promote your own software :-)
"sqlexp" does this.
It's a commandline tool that produces SQL statements. <http://www.dondorp.com/sqlexp.html> for more info.

        Erwin

Patrick Dewael wrote:
> 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
Received on Fri Jul 14 2000 - 00:00:00 CDT