RE: Cannot Disable Constraints

From: Mercadante, Thomas F \(LABOR\) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Thu, 12 Apr 2007 15:17:24 -0400
Message-ID: <ABB9D76E187C5146AB5683F5A07336FFE08D0C@EXCNYSM0A1AJ.nysemail.nyenet>

Donald,

What is your error? Are you able to truncate all of the tables, or is the fact that a constraint exists (even though disabled) preventing your truncate from working?

Tom

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Freeman, Donald Sent: Thursday, April 12, 2007 2:17 PM
To: oracle-l_at_freelists.org
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 constraints.

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.

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Apr 12 2007 - 14:17:24 CDT