ORA-01763: update or delete involves outer joined table



ORA-01763: update or delete involves outer joined table..

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

PLS-00205: Aggregate not allowed here

1 Answers  


ORA-38494: column in the table alias and an attribute have matching names

1 Answers  


ORA-07843: sllfcl: LIB$FREE_VM failure

1 Answers  


PCC-00137: Invalid use of SQL cursor host variable

1 Answers  


NNL-00900: NO SUCH NAME responses sent: number

1 Answers  






RMAN-08024: channel string: restore complete

1 Answers  


ORA-01914: invalid auditing option for sequence numbers

1 Answers  


ORA-07847: sllfop: $CONNECT failure

1 Answers  


RMAN-08160: script commands will be loaded from file string

1 Answers  


ORA-25454: error during evaluation of rule set: string.string for iterator: string

1 Answers  


ORA-00353: log corruption near block string change string time string

1 Answers  


ORA-19563: %s header validation failed for file string

1 Answers  


Categories