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
- 9493 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-06126: NETTCP: ORASRV unable to open network connection
ORA-02797: No requests available
ORA-19903: test recovery not allowed when recovering to new incarnation
PROT-00007: Failed to open the specified import file
ORA-39150: bad flashback time
QSM-02066: Oracle error: see RELATED_NUM and RELATED_TEXT for details
ORA-25100: TABLESPACE option can only be used with ALTER INDEX REBUILD
RMAN-06134: host command complete
ORA-14258: invalid partition description
CLSR-00522: Resource string is not registered
NZE-29027: Error in entropy collection
In VB program, I got message as " No Transaction is Active" , Backend database is Oracle, This message is coming some user's PC and Not all user's PC Please help me to resolve this issue
Oracle Errors 
