intoxicated_curveball
asked on
Can't See Oracle DB Tables using Oracle SQL Developer
Hello, I'm using Oracle SQL Developer to view some Tables. I have verified by connection information is accurate however when I try to open/view the Tables there are none. My vendor tells me it should work... When I hover over the Tables in the tree I see the following message/error:
TABLES (/**/OBJECT_NAME NOT IN (SELECT OBJECT_NAME FROM RECYCLEBIN) AND NOT OBJECT_NAME LIKE 'BIN$%'])
TABLES (/**/OBJECT_NAME NOT IN (SELECT OBJECT_NAME FROM RECYCLEBIN) AND NOT OBJECT_NAME LIKE 'BIN$%'])
Which version of SQL Dev are you using? If you expand your connection folder you should see something like "Tables (Filtered)" - right click on that and select Clear Filter. That should give you a full list of tables in that schema.
ETA: I believe dvz got it, his 2nd point is most likely your issue.
ETA: I believe dvz got it, his 2nd point is most likely your issue.
ASKER
Hi Dvz, this is my first time using Oracle DB or Oracle SQL Developer. So I'm not supposed to expand the root Table then? I don't see my username in "Other Users"?? To be honest only the "Other Users" item has anything in it... shows hundreds of usernames or something but don't see mine.
Btw I've tried both versions 3.2.0.9 and 3.1.0.7.
Gatorvip I tried Clear Filter but didn't help.
Btw I've tried both versions 3.2.0.9 and 3.1.0.7.
Gatorvip I tried Clear Filter but didn't help.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
1. In the worksheet, are you able to confirm the tables with a simple "SELECT tablename from sys.user_tables;" ? To view any tables in your own schema.
2. You may already know that newcomers to the tool expand the highest "tables" and expect to view everyone's tables. Rather, we all learn to expand "Other Users" instead. Does that come into play here?