RE: Cannot Disable Constraints

  • From: "Mercadante, Thomas F \(LABOR\)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
  • To: <dofreeman@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 16 Apr 2007 08:15:14 -0400

I need to have my meds adjusted.  Could have sworn I saw this last
Monday too.


Must be glitch in the Matrix.


This transmission may contain confidential, proprietary, or privileged 
information which is intended solely for use by the individual or entity to 
whom it is addressed.  If you are not the intended recipient, you are hereby 
notified that any disclosure, dissemination, copying or distribution of this 
transmission or its attachments is strictly prohibited.  In addition, 
unauthorized access to this transmission may violate federal or State law, 
including the Electronic Communications Privacy Act of 1985.  If you have 
received this transmission in error, please notify the sender immediately by 
return e-mail and delete the transmission and its attachments.


From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Freeman, Donald
Sent: Thursday, April 12, 2007 2:17 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Cannot Disable Constraints


We are having a problem with one of our development databases and have
been working on this thing since 8 this morning.   We are trying to
refresh code tables, which we do all the time, and are getting
constraint violation errors.   I can't think of anything that has
changed on this database.

We spin through the schema, disable constraints on the code tables,
truncate the tables, import new code values, and reenable the

After we disable the constraints we find that we cannot truncate about
ten tables and get a constraint violation error.   All the constraints
appear to be disabled.   I cannot figure this out.  We have to move
ahead and are going to drop the whole schema and reimport the whole
thing.   What could cause this problem?   I know we are missing
something but I'm not sure what.    We are out of ideas for now.

Other related posts: