Re: Re:Re: recreate constraints script - URGENT

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" <ORACLE-L_at_fatcity.com> 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
> >
> >>>> sysmgr_at_netlimit.com 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: sysmgr_at_netlimit.com
> >
> >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: ListGuru_at_fatcity.com (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: RROGERS_at_galottery.org
> >
> >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: ListGuru_at_fatcity.com (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: sysmgr_at_netlimit.com
>
> 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: ListGuru_at_fatcity.com (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: tanel.poder.003_at_mail.ee

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: ListGuru_at_fatcity.com (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).