Toad World® Forums

No Tables in Object Explorer


#1

How do I get the tables to show in Object Explorer? I can’t use the query builder because no tables show up for my Oracle databases.

Thanks,
Michele

11-8-2010 4-23-20 PM.jpeg


#2

Do you access the tables through synonyms? If so they would be on the synonym tab. Or are they materialized views, etc.

You should see all tables owned by you in the table list.

Can you send a screenshot of the results of this query?

select * from ALL_objects a
where a.OWNER = ‘MCOLSON’

Debbie


#3

It came up with no results.


#4

Then your logid must not have any privileges to see any objects.

Try using the table editor to create a table. When done it should display in the table list.

Also, what do you see when you go to the synonym tab. Perhaps you have access to the tables you want through public synonyms.

Debbie