Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to convert Oracle tables/views etc to text files
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.
--
Phone: (612)626-7135 Fax: (612)625-6853Received on Thu Jan 07 1999 - 08:17:55 CST
---------------------------------------------------------