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: Questions about constraints

RE: Questions about constraints

From: Schauss, Peter <pschauss_at_northropgrumman.com>
Date: Wed, 19 Mar 2003 06:41:10 -0800
Message-Id: <24715.322374@fatcity.com>


This message is telling you that your insert violates the primary key constraint for the table. This means that the primary key, KUNHOD_TMP1_ID, value in your inserted record already exists in the table.

HTH,
Peter Schauss

-----Original Message-----
From: roland.skoldblom_at_ica.se [mailto:roland.skoldblom_at_ica.se] Sent: Wednesday, March 19, 2003 4:16 AM
To: Multiple recipients of list ORACLE-L Subject: Questions about constraints

Hallo,

I get this errormessage while inserting to this table. How can I check this constraint problem? Any wrong with the table definition

9.03.2003 09:46:38 Db_Transfil.AVSTEM -> ORA-20000: db_filtype_ik.AVS

                      TEM: -> ORA-20000: db_filtype_ik:OVERFOR_TIL_KUN:

- > ORA-20000: SKRIV_kuponghod_TMP1: -> ORA-00001:
unique constraint (A172421.KUPONGHOD_TMP1_PK) vio lated

CREATE TABLE KUPONGHOD_TMP1 (
  KUNHOD_TMP1_ID VARCHAR2 (15) NOT NULL,

  TRANSFIL_ID     NUMBER (10)   NOT NULL,
  AVDNR           NUMBER (6)    NOT NULL,
  KUNDEID         NUMBER (16),
  KASSERERID      NUMBER (6)    NOT NULL,
  KASSEID         NUMBER (10)   NOT NULL,
  BONGID          NUMBER (11)   NOT NULL,
  DATO            DATE          NOT NULL,
  CONSTRAINT KUPONGHOD_TMP1_PK
  PRIMARY KEY ( KUNHOD_TMP1_ID )
    USING INDEX
     TABLESPACE INNTEMPIX PCTFREE 10
     STORAGE ( INITIAL 1024K NEXT 1024K PCTINCREASE 0 ))
   TABLESPACE INNTEMP
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE (
   INITIAL 1048576
   NEXT 1048576
   MINEXTENTS 1
   MAXEXTENTS 505
   FREELISTS 1 FREELIST GROUPS 1 ) Thanks in advance

Roland

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: roland.skoldblom_at_ica.se

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
Received on Wed Mar 19 2003 - 08:41:10 CST

Original text of this message

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