Oracle Database 12c New Features

ORA-01763: update or delete involves outer joined table

ORA-01763: update or delete involves outer joined table


Cause:


For deletes, the table being deleted from is outer joined to some other table. For updates, either the table being updated is outer- joined to some other table, or some table reachable from the primary table is being outer joined to a table not reachable from the primary table.



Action:


Change the join specification.