See all tables within an oracle dblink

I need to see all the tables within a dblink'd schema in oracle. What is the query to see all tables?
Who is Participating?
slightwv (䄆 Netminder)Connect With a Mentor Commented:
Try this:
select table_name from all_tables@dblinkname;
radcodersAuthor Commented:
Thanks that worked!
slightwv (䄆 Netminder) Commented:
Glad to help.

I suppose I should also point out that there is a USER level view that will show you the tables owned by the user used in the dblink.

ALL level views show everyhing this user can access.

User level:
select table_name from user_tables@dblinkname;
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.