RE: Script to reverse engineer all objects in a schema to DDL?

From: Andy Duncan <andy_j_duncan_at_yahoo.com>
Date: Tue, 03 Apr 2001 12:27:40 -0700
Message-ID: <F001.002E0385.20010403122319@fatcity.com>

Hi Chris,

You could use Richard Sutherland's exciting Perl work, with his new DDL::Oracle Perl module, and it's associated scripts, which you can find here:

=> http://www.perl.com/CPAN-local/modules/by-authors/id/R/RV/RVSUTHERL/

Richard and I have also started embedding this automatically too within the Orac Perl/Tk Perl DBI program, which now has Oracle development options, as well as DBA login options, which you can find here:

=> http://www.perl.com/CPAN-local/modules/by-module/DBI/ANDYDUNC/

You do have to load Perl, Perl/Tk, Perl DBI and DBD::Oracle (on Windows, Linux, Solaris etc), but once you have all that (and why would you not want to? :), Orac should just run straight up, with a host of scripts to reverse engineer many/all? parts of the Oracle database (and now updated by Richard to work with Oracle 8.1.7, parallel servers etc) or at least it hopefully will when you run it, as we're still very ALPHA at the moment 8)

Orac is still very much a DBA tool, but we are progressing as rapidly as we can with the developer options.

Rgds,
AndyD

andy_j_duncan_at_yahoo.com

O'Reilly's "Oracle and Open Source":
=> http://www.oreilly.com/catalog/oracleopen/

Orac, Perl/Tk and Perl DBI Database DBA & Development Tool:
=> http://www.perl.com/CPAN-local/modules/by-module/DBI/ANDYDUNC/

Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Andy Duncan
  INET: andy_j_duncan_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue Apr 03 2001 - 14:27:40 CDT