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-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
> also send the HELP command for other information (like subscribing).
Received on Wed Mar 19 2003 - 08:25:34 CST