ORA-00001
FDPSTP failed due to ORA-00001 : unique constraint (index_name) VIOLATED
FDPSTP failed due to ORA-00001 : unique constraint (FAH.SYS_C00201026) VIOLATED
I have come across this error while i was running the concurrent program to insert the client data into other table.
This occurs when you try to execute an INSERT or UPDATE statement that has created a duplicate value in a field restricted by a unique constraint.
The option(s) to resolve this Oracle error are :
- Option1 is to Drop the unique constraint.
- Option2 is to Change the constraint to allow duplicate values.
- Option3 is to Modify your SQL so that a duplicate value is not created.
SELECT DISTINCT table_name
FROM all_indexes
WHERE index_name = 'SYS_C00201026';
To find the column and the position of it on which the unique constraint was violated run the below query :
SELECT column_name, position
FROM all_cons_columns
WHERE constraint_name = 'SYS_C00201026' --INDEX_NAME
AND owner = 'APPS' --OWNER
AND table_name = 'XX _FINC_TRANSACTIONS_TEMP'; --TABLE_NAME
Challa.
No comments:
Post a Comment