Solution : https://service.sap.com/sap/support/notes/23237 (SAP Service marketplace login required)
Summary :
This SAP Note addresses the issues related to ORA error messages concerning unique constraint violations across various database operations like insert, import, and index creation. The errors stem from attempts to duplicate primary key values already present in the database, which blocks the successful execution of operations. The solution involves identifying and removing or resolving duplicate records to ensure data integrity and consistency. Detailed SQL commands are provided to assist users in identifying duplicate rows using the primary key columns of the specified tables. Post identification, either the old record needs to be deleted or updated to allow the insertion or update of new data.
Key words :
'analyze table xxx validate structure cascade' returns, enable constraint failed - duplicate keys found' reason, update t_tab set k_col2 = zzzwhere rowid = 'xxxxxxxx, table returns error ora-0001 unique constraint violated 2, ora<sid> unix account start sqlplus, 'ora-1499 table/index cross reference failure' 4, rows whith duplicate keys, database internal unique id, primary key constraint fails, sqlplus> create index t_tab_i
Related Notes :
541538 | FAQ: Reorganization |
26379 | DUPREC for INSERT (due to sec. index or trigger) |