CODEWITHSUNDEEP
oracle-databaseoracle11g
Heedo Kim
Heedo Kim

Reputation: 97

How can I find the invisible table in oracle 11g?

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?

Upvotes: 4

Views: 3606

Answers (2)

hemalp108
hemalp108

Reputation: 1249

You can check in ALL_OBJECTS if you are not sure about the type of an object. It will provide you the Types and other important details also.
For Materialized view please check ALL_MVIEWS.

SELECT *
FROM   ALL_OBJECTS
WHERE  OBJECT_NAME='IM_RESULT_INFO';

Upvotes: 7

pablomatico
pablomatico

Reputation: 2242

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'

Upvotes: 8

Related Questions