Return: 805 - ORA-00001: unique constraint (SYSADM.TABLE) violated

When I try to insert data into TABLE, this error occurs.

The reasons caused the error can be concluded as below

1. Duplicate records.

 

	ID	TYPE	SCHOOL
1	1	C	HKUST
2	1	C	HKUST

2. Duplicate records with the key.

For example, TABLE A use field ID and TYPE as key.

Data of key fields are same.

	ID	TYPE	SCHOOL
1	1	C	HKUST
2	1	C	CITYU

To avoid the case, please make sure the uniqueness of data. 

确保事务的ACID.

A Atomic 原子性

C Consistency 一致性

I Isolation 隔离性

Durability 持久性

 

If in PeopleSoft, remember to truncate table " %TruncateTable(%Table(temporary table))" before "insert into temporary table".