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

Thanks
 No, but I only want a ddl to extract a contraints and all its dependants, I think there must be one tested somewhere , but the problem is I can't find it.
I don't want something to get all the ddls. Only the specific to one constraint. I'm busy and want to save time.  

Juan Carlos Reyes Pacheco
OCP
-------Original Message-------
 

From: Post, Ethan
Date: 12/17/04 12:05:41
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?  

-----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, I don't know if some one could help.  

Thanks.  

Juan Carlos Reyes Pacheco
OCP
--

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

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