Oracle Error ORA-01752: cannot delete from view without exactly one key-preserved table

Oracle Error Message

ORA-01752: cannot delete from view without exactly one key-preserved table

Reason for the Error

The deleted table had

– no key-preserved tables,

– more than one key-preserved table, or

– the key-preserved table was an unmerged view.

Solution

Redefine the view or delete it from the underlying base tables.