CODEWITHSUNDEEP
databaseoracle-databasepentaho
user2449509
user2449509

Reputation:

Oracle unique constraint error ORA 0001

Hi I am using pentaho to insert some values from one DB to another DB. In my source I have an attribute which is the primary key of that table. At my destination I have the same attribute as a unique constraint. But still I get a ORA-00001: unique constraint violated error while inserting. I am not sure why this is can anyone help ? 

Source:
table
( 
empid(PK),
empname
)

Destination:
 table1
 (
 empgroupid(PK)
 empid(unique)
 )

source to destination error: ORA-00001: unique constraint violated

Upvotes: 0

Views: 2134

Answers (1)

Brian.D.Myers
Brian.D.Myers

Reputation: 2518

You likely don't want "table1"."empid" to be unique; you probably want it to be a foreign key to "table"."empid". Especially if an employee can be in more than one group at once.

Upvotes: 0

Related Questions