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: "Mu
Thanks Rajendra, Good idea but I have 1200 tables :(I got a good
script from our list long time ago but lost it.That script can capiture
constraints for the schema owner.
--
Original Message
Date: Tue, 30 Dec 2003 11:39:26 -0800
>run the sam
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