Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

OCI-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.