Ora-02292: integrity constraint (XX) violated – child record found foreign key Association, record cannot be deleted

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: