Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: retrieve database schema

Re: retrieve database schema

From: Steven Hauser <hause011_at_garnet.tc.umn.edu>
Date: 6 Mar 2001 14:47:01 -0600
Message-ID: <983ic5$lnt$1@garnet.tc.umn.edu>

http://www.sofbot.com/

script called ugly_DDL uses oracle exp and imp utilities with awk to get runable SQL DDL from Oracle.

Oracle's motto is "Never let the people get porting data."

Also there are several other PL/SQL and perl based schema generators using exp,imp or the system catalogs to generate some DDL. Search the Web and oramag.

-- 

---------------------------------------------------------
Steven Hauser email: hause011@tc.umn.edu URL: http://www.sofbot.com/
---------------------------------------------------------
Received on Tue Mar 06 2001 - 14:47:01 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US