如何列出数据库链接(Oracle)中存在的所有表? [英] How can I list all tables existent in a Database Link (Oracle)?

问题描述

基本上，我有一个名为 mylink.domain 的数据库链接(Oracle)，在此链接中，我们可以访问基础信息，例如它们的成员名称和其他常规信息.

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.

预先感谢

推荐答案

您可以访问

You can access the all_tables view through the dblink:

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

这篇关于如何列出数据库链接(Oracle)中存在的所有表?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！