1

I am connecting to oracle 11 DB.

When I connect with PL/SQL, I can explore all the objects :

enter image description here

However when accessing this same DB using Oracle SQL Developer, expanding the different objects results in empty list

enter image description here

Any ideas why this might be?

1 Answer 1

1

SQLDeveloper shows tables that are owned by the logged in user. To see other users' tables, right click on connection ("dev" in your case), click "Schema Browser", and then select a user whose object you want to see.

Or directly query system views (e.g. all_tables )

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.