| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Script to reverse engineer all objects in a schema to DDL?
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
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/
-- 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
 |
 |