CODEWITHSUNDEEP
oracle10g
sentil
sentil

Reputation: 59

Unique key constraint violation in oracle 10g?

i am loading data from flat file to table with help of sql* loader in oracle10g.

but while loading it is showing the below error.

*

ERROR at line 1:
ORA-00001: unique constraint (SANFORDINTEGRATOR.SUBSCRIBER_ID_PK) violated
ORA-06512: at "SANFORDINTEGRATOR.DATAMOVE", line 26
ORA-06512: at line 1

How can i resolve it.

thanks in advance

Upvotes: 1

Views: 1011

Answers (1)

Codo
Codo

Reputation: 78835

The table SANFORDINTEGRATOR has a constraint that requires a column (probably SUBSCRIBER_ID) has unique values (probably because it's the primary key). You're obviously loading data that doesn't have unique values for this column. So Oracle rejects it.

To fix it, make sure the SUBSCRIBER_ID are unique (both accross your file and the already existing data in the table).

Upvotes: 2

Related Questions