Set up the contraint(s) as "deferrable" and with a simple "alter session"
command you can defer constraint checking until commit time for all tables .
--
"Albert Zweistein" <azwei_at_web.de> wrote in message
news:Xns93C0B854DF3A1azweiwebde_at_62.243.74.162...
> I need one or two PL/SQL's that will let me
>
> - Disable ALL Constraints for one or more tables
>
> and at a later time
>
> - Enable ALL Constraints for one or more tables
>
>
> Please post any answers to the Newstgroup.
>
>
> Thanks - Albert !
Received on Wed Jul 23 2003 - 23:27:48 CDT
