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..

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

ORA-32306: updatable materialized views with user-defined types must use SELECT *

1 Answers  


QSM-02071: internal error: undefined PCT failure code

1 Answers  


PCC-02021: Found newline while scanning string literal

1 Answers  


LFI-00135: Unable to remove temporary file.

1 Answers  


PCC-00008: Invalid WHENEVER action at column number in line number of file string

1 Answers  






ORA-25196: keyword MOVE in ALTER TABLE MOVE must immediately follow <table name>

1 Answers  


ORA-40211: algorithm name string is invalid

1 Answers  


TNS-00526: No caller (false async event)

1 Answers  


DGM-17002: Primary database can not be removed.

1 Answers  


RMAN-20003: target database incarnation not found in recovery catalog

1 Answers  


ORA-37014: (XSACQUIRE_ACQUIRED) Object workspace object is already acquired.

1 Answers  


ORA-29370: pending area is already active

1 Answers  


Categories