RE: Script to get ddl from constraints (and its dependants ) incl uding foreign keys to recreate

I concur with this recommendation. Data wizard, formerly Data Hornet DBA Tool, is an excellent freeware tool for extracting DDL definitions from an Empty (rows=no) export file. It works on MS-Windows and it works under influence, when using WINE. DDL Wizard under influence is popularly known As DUI.
The link is: http://www.ddlwizard.com/
--

Mladen Gogala
Ext. 121

-----Original Message-----

From: Post, Ethan [mailto:Ethan.Post_at_ps.net] Sent: Friday, December 17, 2004 11:03 AM To: jreyes_at_dazasoftware.com; oracle-l_at_freelists.org Subject: RE: Script to get ddl from constraints (and its dependants ) including foreign keys to recreate

did you try ddlwizard?=20

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Juan Carlos Reyes Pacheco
Sent: Friday, December 17, 2004 9:37 AM
To: oracle-l_at_freelists.org
Subject: Script to get ddl from constraints (and its dependants ) including foreign keys to recreate

 Hi, I had been RTFM some hours, and I can find a script  to change a constraint
this is get the constraint ddl and all the constraints using that constraint

Using dbms_metadata I couldn't get foreign keys ddl,=20 I don't know if some one could help.

Thanks.
=20
Juan Carlos Reyes Pacheco
OCP
--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Fri Dec 17 2004 - 10:47:34 CST