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-13383: inconsistent network metadata: string

1 Answers  


TNS-01060: The password has has been set to: string

1 Answers  


ORA-40206: invalid setting value for setting name string

1 Answers  


ORA-24069: cannot downgrade queue table string while it is being upgraded

1 Answers  


ORA-24198: attempt to use an invalid operation ID

1 Answers  






IMG-00844: internal image data allocation failed

1 Answers  


ORA-36712: (XSMXALLOC02) Relation workspace object must be a one-dimensional self-relation to be used as a SOURCE or BASIS with ALLOCATE.

1 Answers  


PCC-01201: Your Pro*C authorization is about to expire

1 Answers  


ORA-38465: failed to create the privilege checking trigger due to: string

1 Answers  


ORA-01662: tablespace 'string' is non-empty and cannot be made temporary

1 Answers  


LPX-00110: invalid ~1s "~2S" (not a Name)

1 Answers  


DRG-10606: server failed to access the DML Queue

1 Answers  


Categories