Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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
Received on Fri Dec 17 2004 - 09:58:51 CST
![]() |
![]() |