Re: Disabling check constraints

Alex wrote:
> Hi all,
> I want to be able to disable constraints, perform a number of updates,
> then re-enabling the constraints. I need to do this because some of the
> updates in a batch will break constraints rule
> during the batch but by the end everything should be consistent.

If you were talking about Foreign Key Constraints your request would be logical. But I am not aware of any means by which this could be true with Check Constraints.

Are you sure you are asking the question you intend? In what version of Oracle?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org