ORA-00001: Unique constraint (OWNER.CONSTRAINT_NAME) violated Typically an application error message.
The constraint indicated in the error message is a unique or primary key on a table.
An attempt was made to insert a record with a key that already exists in that table. This is not allowed and thus violates the constraint.
you can use following statement to identify the columns of the table this constraint is based upon:
select table_name, column_name
from all_cons_columns
where owner='<Here OWNER>'
and constraint_name='<Here CONSTRAINT_NAME>'
order by position;
 Forum Messages
I have one table with five fields.
I can insert data into the table. No problem.
When I try to login by using one field of the table.the following error occurred.
service-j2ee reports: StandardWrapperValve[jsp]: WEB2792: Servlet.service() for servlet jsp threw exception
javax.servlet.ServletException: ORA-00001: unique constraint (TIC.SYS_C0010331) violated
at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:536) |
| : -> 07-FEB-2008 08:27:09 | Trigger? | DbMotive | Reply |
Is there a trigger defined on the table that inserts data into another table, which generates this UNIQUE KEY violation error?
Check on what table the contraint is defined:
select table_name, column_name
from all_cons_columns
where owner='TIC'
and constraint_name='SYS_C0010331'
order by position;
|
I've installed oracle database 10g on my pc under windows server 2003 and i've done the import of tables.For some reason I redid this import so i received :
ORA-00001:unique contraint (ADMIN.BELM_PK) violated.
Is this a normal response? |
| : -> 13-FEB-2008 08:53:49 | Double import | DbMotive | Reply |
Yes, this is expected behaviour.
The data already exists in the tables. A primary key constraint prevents duplicates from being created.
|
Add your message for ORA-00001
| 
Home