asked on

Querable table does not appear in USER_OBJECTS

Hi!

Through a debug-mode in the application I am working with, I found that the information was stored in a table(?) called anvandare.

In sqldeveloper where I have high privilieges, I can query the table in a window e.g. like this

select * from anvandare

However it does not appear when I make a query like this

SELECT * FROM USER_OBJECTS
WHERE OBJECT_NAME LIKE '%anv%'

or in the list of all table in sqldeveloper.

Question:

1. What could be the possible reason for the non-appearence of the table be?
table-sqldveloper.png

Sean Stuber

different schemas

sqldeveloper will use the ALL_TABLES view

marcgu

ASKER

I doesnt appear when I write

select * from all_tables either or did I missanderstand your answer. I just want to be able to get more metadata about the table like datatypes, constraints etc.

SOLUTION

Sean Stuber

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

johnsone

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

David VanZandt

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

marcgu

ASKER

Hi!

ANVANDARE had the object_type SYNONYM and I found it when I queried SYS.ALL_OBJECTS. Now, I can go on Learning more about SYNONYMS. Thanks a lot.