How can I find the invisible table in oracle 11g?
oracle, oracle11g
Solution
It must be a synonym or a view, check the synonyms view to see what object is referenced by it:
SELECT *
FROM all_synonyms
WHERE synonym_name = 'IM_RESULT_INFO'
Or the views view:
SELECT *
FROM all_views
WHERE view_name = 'IM_RESULT_INFO'
Problem
There is a table named `IM_RESULT_INFO`. Because I can see it by `SELECT * FROM IM_RESULT_INFO`. But it doesn't exist in table nor view lists in sqldeveloper. I also tested `SELECT * FROM all_all_tables` and `SELECT * FROM dba_tables`, and couldn't find the table. In Eclipse IDE, I searched for it in whole project files, but the only code I found was `SELECT ... FROM IM_RESULT_INFO`. I think it is a mixture of tables, but there's no way to analyze it. How can I find it?