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.
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.
Open the view. Open the Dependencies panel. There's my list of tables.
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.
Select 'Other Users' from the and select your user(schema), under which you will be able to see your tables and views.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With