You are trying to insert a row that contains values that already exist in the table, and there is a constraint on the table that says the values for the row(s) must be unique.
Now about that column BONGID ... What are you smoking? > -----Original Message----- > > 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: Stephen Lee 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).
