Thursday 19 January 2012

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.

No comments:

Post a Comment