Tables and Views are not displaying any objects.

881668 Sep 24, 2013 3:34 PM

I have tried both Filtered and non-filtered for tables and view but it won't list any tables or view.

I can run a query and it shows all the tables/views in the query window.

SELECT table_name FROM dba_tables

select view_name from all_views

1. Re: Tables and Views are not displaying any objects.

Jim Smith Sep 24, 2013 4:05 PM (in response to 881668)

Who owns the objects?

The browser only shows objects owned by the current logged in user in the main section. You need to go into the Other Users node to find objects owner by other users.
Like Show 0 Likes(0)

Actions
2. Re: Tables and Views are not displaying any objects.

881668 Sep 24, 2013 4:09 PM (in response to Jim Smith)

Thank you!
Like Show 0 Likes(0)

Actions
3. Re: Tables and Views are not displaying any objects.

881668 Sep 24, 2013 5:57 PM (in response to Jim Smith)

Jim,
I can see all tables and view under "Other Users" but how do I run a select statement?
There is a table db named "COURSES" under "Other Users" and I want to select top 10 records from a table named "Selection"
Like Show 0 Likes(0)

Actions

Join the world’s largest interactive community dedicated to Oracle technologies.