Tips for Oracle DBA
Oracle Database Administration, How To, Daily DBA jobs, Oracle Error Cause and Action
Oracle DBA, How To, Error, Cause and Action
Back To Menu
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.
Newer Post
Older Post
Home