Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-24433: This statement has already been prepared using OCIStmtPrepare2.

1 Answers  


ORA-01526: error in opening file 'string'

1 Answers  


DRG-11480: ctxkbtc memory allocation error: %(1)

1 Answers  


QSM-02121: set operator in a context not supported for fast refresh

1 Answers  


ORA-26040: Data block was loaded using the NOLOGGING option

1 Answers  






ORA-32636: Too many rules in MODEL

1 Answers  


NNO-00326: server statistic counter dump follows

1 Answers  


ORA-13270: OCI error string

1 Answers  


ORA-01695: error converting rollback segment string to version 8.0.2

1 Answers  


RMAN-00577: PIPE requires that TARGET be specified on the command line

1 Answers  


ORA-22923: amount of data specified in streaming LOB write is 0

1 Answers  


QSM-01115: rollup took place on a column with a window function

1 Answers  






Categories