Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-01719: outer join operator (+) not allowed in operand of
OR or IN
- 2 Answers
- 9399 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
Cause: An outer join appears in an or clause.
Action: If A and B are predicates, to get the effect of
(A(+) or B), try (select where (A(+) and not B)) union all
(select where (B)).
Please add more information about this Error
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / krishna m m
Action: If A and B are predicates, to get the effect of
(A(+) or B),
try (select where (A(+)) union (select where (B)).
But union will take more time. This will tend to perofmance
issue, if the records are more.
| Is This Answer Correct ? | 1 Yes | 0 No |
ORA-02718: osnprs: reset protocol error
IMP-00013: only a DBA can import a file exported by another DBA
ORA-09217: sfsfs: failed to resize file
NID-00131: Control file is not current
ORA-01106: database must be closed before dismounting
ORA-14624: DEFAULT subpartition must be last subpartition specified
ORA-26690: datatype not supported at non-Oracle system
ORA-27417: BYWEEKNO clause is only supported when FREQ=YEARLY
ORA-01521: error in adding data files
KUP-02004: quoted string too big
ORA-29909: label for the ancillary operator is not a literal number
ORA-30151: File already exists
Oracle Errors 
