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.
