RE: Questions about constraints
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-2: db_filtype_ik.AVS TEM: -> ORA-2: db_filtype_ik:OVERFOR_TIL_KUN: - > ORA-2: SKRIV_kuponghod_TMP1: -> ORA-1: 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, DATODATE 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).
RE: Questions about constraints
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-2: > db_filtype_ik.AVS > TEM: -> ORA-2: > db_filtype_ik:OVERFOR_TIL_KUN: > - > ORA-2: SKRIV_kuponghod_TMP1: -> > ORA-1: >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, > DATODATE 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).
