通过db_links查看数据库之间关联的
通过 select * from ALL_DB_LINKS where DB_LINK like '%MATT_ERP%';获取如下数据
| OWNER | DB_LINK | USERNAME | HOST | CREATED |
| PUBLIC | MATT_ERP | MATT_ERP | YY2CUSDB | 30-7月 -14 |
然后通过 select * from all_tables@MATT_ERP where table_name like '%表名%';获取可以访问的表
通过 select * from ALL_DB_LINKS where DB_LINK like '%MATT_ERP%';获取如下数据
| OWNER | DB_LINK | USERNAME | HOST | CREATED |
| PUBLIC | MATT_ERP | MATT_ERP | YY2CUSDB | 30-7月 -14 |
然后通过 select * from all_tables@MATT_ERP where table_name like '%表名%';获取可以访问的表
