RE: Cannot Disable Constraints
- From: Tanel Poder <tanel.poder.003@xxxxxxx>
- To: dofreeman@xxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Sat, 14 Apr 2007 13:22:00 +0800
An error code with text and constraint name would be helpful. There are
different types of constraints which can be violated...
Also if you trace your session (with binds) when trying to truncate the
tables you could get a step closer to the root cause...
Tanel.
_____
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Freeman, Donald
Sent: Friday, April 13, 2007 02:17
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 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.
Other related posts:
