Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Oracle SQL Developer - tables cannot be seen

I was using SQL Developer 1.1. I have recently upgraded to SQL Developer 3. After the upgrade, I noticed that some of my connections do not show their tables. I can do a select on the tables and the data is shown. I can see other objects like views etc. I can still use my older version and can see all the tables listed fine for the same schemas. There are other connections that show up fine though.

Cannot seem to find information on this. I tried removing the filter but it didn't work.

Did anybody run into this? Please help.

like image 703
sammy Avatar asked Apr 21 '11 20:04

sammy


People also ask

Why can't I see tables in Oracle SQL Developer?

Post updated November 12, 2018. The answer is simple – you can't see any tables, because you don't OWN any tables. I hate to be the bearer of bad news, but you don't have any tables.

How do I find the tables in a view in SQL Developer?

Open the view. Open the Dependencies panel. There's my list of tables.


2 Answers

The tables you are looking for are probably in a different schema. There are a couple of options. You can either click on Other Users in the tree under your connection, or right click on the connection and select Schema Browser and then select the desired schema.

like image 165
Michael Munsey Avatar answered Oct 02 '22 16:10

Michael Munsey


Select 'Other Users' from the and select your user(schema), under which you will be able to see your tables and views.

Screenshot

like image 26
Vinay s.c. Avatar answered Oct 02 '22 18:10

Vinay s.c.