RE: Cannot Disable Constraints

From: Kerber, Andrew W. <Andrew.Kerber_at_umb.com>
Date: Thu, 12 Apr 2007 14:17:18 -0500
Message-ID: <D40740337A3B524FA81DB598D2D7EBB307EEFF84@x6009a.umb.corp.umb.com>

Perhaps there is a constraint on a table outside the schema? What is the error message you get?

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Freeman, Donald Sent: Thursday, April 12, 2007 1: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.

NOTICE: This electronic mail message and any attached files are confidential. The information is exclusively for the use of the individual or entity intended as the recipient. If you are not the intended recipient, any use, copying, printing, reviewing, retention, disclosure, distribution or forwarding of the message or any attached file is not authorized and is strictly prohibited. If you have received this electronic mail message in error, please advise the sender by reply electronic mail immediately and permanently delete the original transmission, any attachments and any copies of this message from your computer system. Thank you.

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

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