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-----
Sent: Wednesday, March 19, 2003 4:16 AM
To: Multiple recipients of list ORACLE-L
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Schauss, Peter
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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
also send the HELP command for other information (like subscribing).
