what does error ORA-00001 mean? [message #19202] |
Tue, 05 March 2002 02:44 |
Greg Horton
Messages: 37 Registered: February 2002
|
Member |
|
|
Im inserting into a table and am getting the error below. The data is still being inserted into the table despite this error. Should i be concerned?
INSERT INTO branch_table
*
ERROR at line 1:
ORA-00001: unique constraint (HORTONG.SYS_C0041701) violated
|
|
|
Re: what does error ORA-00001 mean? [message #19203 is a reply to message #19202] |
Tue, 05 March 2002 03:19 |
pratap kumar tripathy
Messages: 660 Registered: January 2002
|
Senior Member |
|
|
date will not be loaded if constarints fail. so check it out.
----------------------------------------------------
ORA-00001 unique constraint table.column violated
----------------------------------------------------
Cause:
An update or insert statement attempted to insert a duplicate key.
Action:
Either remove the unique restriction or do not insert the key.
For Trusted Oracle7 configured in DBMS MAC mode, you may see this message if a duplicate entry exists at a different level.
|
|
|