RE: Script to get ddl from constraints (and its dependants ) including foreign keys to recreate
- From: "Juan Carlos Reyes Pacheco" <jreyes@xxxxxxxxxxxxxxxx>
- To: <Ethan.Post@xxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 17 Dec 2004 12:08:45 -0400
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@xxxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Juan Carlos Reyes
Pacheco
Sent: Friday, December 17, 2004 9:37 AM
To: oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
