1、利用dblink创建本地表 (结果:成功)
SQL> create table bb1 as select * from tt1@link_21;
2、利用dblink插入到本地表 (结果:成功)
Table created.
SQL> insert into bb2 select * from tt1@link_21;
1 row created.
SQL> commit;
Commit complete.
******************二、 操作远程表 ******************
3、利用dblink插入到远程表 (结果:成功)
SQL> insert into tt1@link_21 select * from bb2;
2 rows created.
4、利用dblink 创建远程表 (结果:失败)
SQL> create table aa1@link_21 as select * from bb2;
create table aa1@link_21 as select * from bb2
*
ERROR at line 1:
ORA-02021: DDL operations are not allowed on a remote database
Commit complete.
************************三、总结*******************
1、dblink操作本地表(创建本地表,插入本地表)都是成功的
2、dblink操作远程表,有可能失败。插入远程表成功,创建本地表失败。