A reader, March 03, 2017 - 1:46 pm UTC
A reader, March 03, 2017 - 1:50 pm UTC
Thanks Chris!!
the solution
Johan Vankeerberghen, March 27, 2019 - 10:03 am UTC
If the "explain plan" can be build with out this error. Then the problem is probably that the owner of the table is missing.
This alter session will not help:
ALTER SESSION SET CURRENT_SCHEMA=YouTableOwner
The solution:
Add the xxxx. before for table names . xxxx is you table owner.
e.g.
select * from xxxx.table
To find the owner of you table use this following query:
Select owner
from dba_tables
where table_name = 'YOUR_TABLE_NAME'