Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Cannot Disable Constraints

Re: Cannot Disable Constraints

From: GovindanK <gkatteri_at_fastmail.fm>
Date: Mon, 16 Apr 2007 20:17:21 UT
Message-Id: <1176754641.30221.1184915473@webmail.messagingengine.com>

What error are you getting? Did you disable Ref.constraints? Are there any locks?. What version? Any undo segment corruption (9i/10g)?

Subject: OERR: ORA-1329 unable to truncate require build table   Doc ID: Note:172533.1

HTH GovindanK

On Thu, 12 Apr 2007 14:16:43 -0400, "Freeman, Donald" <dofreeman_at_state.pa.us> said:

  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 Mon Apr 16 2007 - 15:17:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US