| 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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
