Re: reverse engineer

Hi!

• On november 08 IAmTheRepoMan wrote:

 I> Does anyone know/have a script that really will reverse engineer an
 I> Oracle 8i db?  I'm looking for something that will capture users
 I> (with tablespaces and quotas), tables (partitions and clusters) and
 I> procedures (both headers and bodies).  Everything I've found so far
 I> doesn't quite cut it.  I'm not against creating my own but don't wish
 I> to reinvent the wheel.  I'd like to do this without a tool such as
 I> Toad, Embarcadero, Erwin or De$igner.

http://sqlbatch.com/sb/ (SQL Batch).

Try this command line utility. It supports customizable DDL extraction for db objects (you can control storage part generation, rename tablespaces, owners, etc with regex'es).
You also can use it like sqlplus or svrmgr with a lot of extensions. Feel free to ask me by email questions regarding using SQL Batch or example scripts

Bye

[SQL Batch: Oracle automation] http://sqlbatch.com/sb/ Received on Fri Nov 09 2001 - 04:43:54 CST