ORA-01417: a table may be outer joined to at most one other table

ORA-01417: a table may be outer joined to at most one other
table

Question Posted / guest

1 Answers
4970 Views
I also Faced
E-Mail Answers

ORA-01417: a table may be outer joined to at most one other table..

Answer / guest

Cause: a.b (+) = b.b and a.c (+) = c.c is not allowed

Action: Check that this is really what you want, then join b
and c first in a view.

Please add more information about this Error

Is This Answer Correct ?

4 Yes

0 No

Post New Answer

More Oracle Errors Interview Questions

RMAN-06426: RECOVERY_CATALOG_OWNER role must be granted to user string

1 Answers

TNS-01000: spawn [<listener_name>] <spawn_alias> [<(ARGUMENTS='arg0, arg1,...')>]

1 Answers

ORA-32315: REFRESH FAST of "string"."string" unsupported after mixed DML and Direct Load

1 Answers

PLS-00116: Duplicate where-clause in table expression

1 Answers

ORA-12995: no columns in partially dropped state

1 Answers

ORA-01575: timeout waiting for space management resource

1 Answers

RMAN-08113: including current SPFILE in backupset

1 Answers

ORA-13755: invalid "SQL Tuning Set" name

1 Answers

RMAN-08135: some corrupt blocks found during conversion of file string

1 Answers

ORA-16172: archive logs detected beyond Terminal End-Of-Redo

1 Answers

NNO-00060: loading server topology from checkpoint file "string"

1 Answers

NZE-28832: invalid data unit format

1 Answers

For more Oracle Errors Interview Questions Click Here