when I run the query below search data from Oracle DB in Cross-connection sql editor ,
select count(1) from
SCBECBHV (RENJERRY), RENJERRY.RENJERRY.DIM_ANSWER;
It shows error:
Category Timestamp Duration Message Line Position
Error 1/2/2016 10:49:05 AM 0:00:00.661 Can’t find database object
SCBECBHV (RENJERRY), RENJERRY.RENJERRY.DIM_ANSWER 1 0
However, I run the query below in sql editor, there is no error.
select count(1) from DIM_ANSWER;
Could anyone help me to solve it?