Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Script to get ddl from constraints (and its dependants ) including foreign keys to recreate

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

From: Post, Ethan <Ethan.Post_at_ps.net>
Date: Fri, 17 Dec 2004 10:02:45 -0600
Message-ID: <83FCA77436D6A14883E132C63F4101D001F5486E@pscdalpexch50.perotsystems.net>


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

Original text of this message

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