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: How to convert Oracle tables/views etc to text files

Re: How to convert Oracle tables/views etc to text files

From: Steven Hauser <hause011_at_garnet.tc.umn.edu>
Date: 7 Jan 1999 08:17:55 -0600
Message-ID: <772fmj$96d$1@garnet.tc.umn.edu>


I have a script that pulls DDL from Oracle imp/exp. It will remove the size and dbspace DDL from the schema if you want.

http://www.tc.umn.edu/~hause011/

The script is ugly_DDL.ksh. The only known script in the FREE world. It is FREE.

Another way if you have money and time is to get ERWin or Power Designer or other database design tool and reverse engineer your database. There are usually text reports available for text DDL.

--  



Steven Hauser, hause011_at_tc.umn.edu
Phone: (612)626-7135
Fax:   (612)625-6853

---------------------------------------------------------
Received on Thu Jan 07 1999 - 08:17:55 CST

Original text of this message

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