There are probably such scripts in internet, or you can write your own in few minutes, but if you need it only once, then one easy way would be just to use TOAD (free/shareware ver) or similar tools to extract scripts of your constraints from database.
Tanel. ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, December 30, 2003 11:09 PM > Thanks Ron, I got this recreate constraints script from our list but > lost it. It was really good script and it can re-generate all the > constraints under a schema owner. > ---------------------------------------------- > Original Message > Date: Tue, 30 Dec 2003 12:14:26 -0800 > > >dba_constraint will inform you of the tables that have constraints and > >what type of constraint they are. > >Further digging into the dba_ tables will provide the information you > >desire. Keep the scripts as part of the database documentation and > >update when needed. > >Third party software can provide the scripts for the entire database. > >Ron > > > >>>> [EMAIL PROTECTED] 12/30/2003 2:24:25 PM >>> > > > >Dear all, I have a script to generate constraints for a single > >table > >but I need a script to generate constraints for a schema owner . Can > >anyone send me a copy? > > > >Many thanks, > > > >_____________________________________________ > >Free email with personality! Over 200 domains! > >http://www.MyOwnEmail.com > >Looking for friendships,romance and more? > >http://www.MyOwnFriends.com > > > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.net > >-- > >Author: system manager > > INET: [EMAIL PROTECTED] > > > >Fat City Network Services -- 858-538-5051 http://www.fatcity.com > >San Diego, California -- Mailing list and web hosting services > >--------------------------------------------------------------------- > >To REMOVE yourself from this mailing list, send an E-Mail message > >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > >the message BODY, include a line containing: UNSUB ORACLE-L > >(or the name of mailing list you want to be removed from). You may > >also send the HELP command for other information (like subscribing). > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.net > >-- > >Author: Ron Rogers > > INET: [EMAIL PROTECTED] > > > >Fat City Network Services -- 858-538-5051 http://www.fatcity.com > >San Diego, California -- Mailing list and web hosting services > >--------------------------------------------------------------------- > >To REMOVE yourself from this mailing list, send an E-Mail message > >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > >the message BODY, include a line containing: UNSUB ORACLE-L > >(or the name of mailing list you want to be removed from). You may > >also send the HELP command for other information (like subscribing). > > > > _____________________________________________ > Free email with personality! Over 200 domains! > http://www.MyOwnEmail.com > Looking for friendships,romance and more? > http://www.MyOwnFriends.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: system manager > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
