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

ORA-12509: TNS:listener failed to redirect client to service handler

1 Answers  


ORA-02142: missing or invalid ALTER TABLESPACE option

1 Answers  


ORA-24505: cannot change character set id on the handle

1 Answers  


NNL-00204: Cancelled shutdown

1 Answers  


ORA-31696: unable to export/import string using client specified string method

1 Answers  






TNS-12210: TNS:error in finding Navigator data

1 Answers  


ORA-24811: less data provided for writing than indicated

1 Answers  


ORA-01163: SIZE clause indicates string (blocks), but should match header string

1 Answers  


ORA-12154: TNS:could not resolve the connect identifier specified

1 Answers  


ORA-01556: MINEXTENTS for rollback segment must be greater than 1

1 Answers  


NNL-00296: Controller's local trace level changed from number to number

1 Answers  


ORA-29276: transfer timeout

1 Answers  


Categories