How can I list all tables existent in a Database Link (Oracle)?

Question

Basically I have a Database link (Oracle) called mylink.domain, in this link we can access foundation information like name of them members and other general information.

I would like to list all table's name in this link but i don't know how to do that.

Thanks in advance

Answer 1

You can access the all_tables view through the dblink:

select owner, table_name
from all_tables@dblink
order by owner, table_name;