CODEWITHSUNDEEP
oracle-sqldeveloper
Gunjan Shah
Gunjan Shah

Reputation: 5168

SQl Table displays no table under connection

I am using Orable DB in my application and SQL Developer Query Browser for UI Purpose.

Today I faced a very strage issue, I run a query in the query browser which gives me records successfully. But under the connection -> Table tree hierarchy, no tables are displayed.

From stackoverflow I got a solution from here : SQLDeveloper displays no tables under connections where it says tables

But under "Other Users" tree, it displays large list of schemas. So I am confused which schema is used by me query.

Any suggestion ??

Upvotes: 0

Views: 131

Answers (1)

Justin Cave
Justin Cave

Reputation: 231661

Assuming that you are running a query that involves an unqualified identifier

SELECT *
  FROM some_object

and that you haven't done something odd like changing the current_schema of the session, the object is either something that exists in your schema or is a public synonym.

SELECT owner, object_type, object_name
  FROM all_objects
 WHERE object_name = 'SOME_OBJECT'

will show you all the objects that you have access to with that name.

Upvotes: 1

Related Questions