Anybody do this stuff by generating the information in OEM? I do. Brian -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Post, Ethan Sent: Friday, December 17, 2004 11:15 AM To: Juan Carlos Reyes Pacheco; oracle-l@xxxxxxxxxxxxx Subject: RE: Script to get ddl from constraints (and its dependants ) including foreign keys to recreate Have not tried ddl wizard but I would think it might have an option to specify what you want extracted right? Have you checked it out? -----Original Message----- From: Juan Carlos Reyes Pacheco [mailto:jreyes@xxxxxxxxxxxxxxxx]=3D20 Sent: Friday, December 17, 2004 10:09 AM To: Post, Ethan; oracle-l@xxxxxxxxxxxxx Subject: 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. =3D20 Juan Carlos Reyes Pacheco OCP -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l