When we delete data with foreign keys, Oracle will prompt: ora-02292: integrity constraint (XX) violated – child record found
Step 1: invalidate the primary key: alter table_ name disable primary key cascade;
Step 2: delete from table_ name where id = ‘xx’;
Step 3: make the primary key effective: alter table_ name enable primary key;
Read More:
- Mysql error 1452 – Cannot add or update a child row: a foreign key constraint fails
- MySQL failed to add foreign key: SQL 1452 cannot add or update a child row:a foreign key constraint fails
- Failed to add the foreign key constraint. Missing index for constraint ‘stu_ibfk_1’ in the reference
- Solution to error 1452: cannot add or update a child row: a foreign key constraint failures in MySQL
- 1822 – Failed to add the foreign key constraint. Missing index for constraint ‘tb_emp_ibfk_1’ in the
- MYSQL ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails
- MySql ERROR CODE：1215 Cannot add the foreign key constraint
- Mysql error when deleting the table structure: Error Code: 1217. Cannot delete or update a parent row: a foreign key constraint fails
- MySQL:Foreign key fails with error Error Code: 1452.
- MySQL failed to add foreign key error 1452
- main.cpp : (. Text + 0xd06): undefined reference to XX method | simple record
- Org.springframework.beans.factory.xml.xmlbeandefinitionstoreexception: the wildcard matching is comprehensive, but the declaration of element XX: XX XX cannot be found
- MySQL error 1451 23000 foreign key exception handling
- Record an error that the Tomcat resource publication cannot be updated:
- MySQL error code 1217 (ER_ROW_IS_REFERENCED): Cannot delete or update a parent row: a foreign key co
- Visio2007 usage record
- DB2 encountered the problem of sqlcode = 911 lock table when updating record update
- [Oracle] when inserting data, “ora-00001: unique constraint” appears
- OpenGL step pit record
- Under win864 bit, install python, PyQt4 and sip. (final failure, only record)