Oracle Error ORA-01763: update or delete involves outer joined table

Oracle Error Message

ORA-01763: update or delete involves outer joined table

Reason for the Error

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.

Solution

Change the join specification.