两个数据库之间查询
//创建Database Link
create database link DEMO_DBLINK connect to demo identified by demo using '192.168.0.1:1521/orcl';
//查询dblink库表
SELECT * FROM suser@demo_dblink;
oracle创建database link
最新推荐文章于 2023-07-12 15:08:09 发布
两个数据库之间查询
//创建Database Link
create database link DEMO_DBLINK connect to demo identified by demo using '192.168.0.1:1521/orcl';
//查询dblink库表
SELECT * FROM suser@demo_dblink;