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
- 9398 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-28221: REPLACE not specified
TNS-02519: no appropriate key-negotiation parameters
ORA-04045: errors during recompilation/revalidation of string.string
ORA-09320: szrfc: unable to obtain the list of valid OS roles
ORA-31513: unsupported column type specified in change table
NZE-29191: OID connection information not set
ORA-39310: illegal clean_failed_clone() call: it only applys to failed clones
ORA-15120: ASM file name 'string' does not begin with the ASM prefix character
LFI-00002: Out of memory. string
ORA-26571: %s.string.string: number of arguments (string) does not match replication catalog
ORA-13207: incorrect use of the [string] operator
ORA-19695: fixed table x$krbmsft has not been populated
Oracle Errors 
