Oracle DBA, How To, Error, Cause and Action

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

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




Cause: The deleted table had :

  • no key-preserved tables,
  • more than one key-preserved table, or
  • the key-preserved table was an unmerged view.





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