在oracle11g中,如果在B库使用dblink查询A库的数据并插入到C数据库中。会报下面的错误:
insert into charis.cha_tt@to_db11g select * from gaok.t_prod4@to_prod4;
ERROR at line 1:
ORA-02019: connection description for remote database not found
ORA-02063: preceding line from PRODCDB
ORA-02063: preceding 2 lines from to_db11g
数据库版本:
B库11.2.0.3
C库11.2.0.3
而在12c的数据库中,同样的操作会成功
SQL> create database link to_db11g connect to charis identified by charis using 'DB11G';
Database link created.
SQL> drop public database link to_prod4 ;
Database link dropped.
SQL>
SQL> create database link to_prod4 connect to gaok identified by gaok using 'PROD4';
Database link created.
SQL>
SQL> insert into charis.cha_tt@to_db11g select * from gaok.t_prod4@to_prod4;
A库12.1.0.2
B库12.1.0.2
C库11.2.0.4
insert into charis.cha_tt@to_db11g select * from gaok.t_prod4@to_prod4;
ERROR at line 1:
ORA-02019: connection description for remote database not found
ORA-02063: preceding line from PRODCDB
ORA-02063: preceding 2 lines from to_db11g
数据库版本:
B库11.2.0.3
C库11.2.0.3
而在12c的数据库中,同样的操作会成功
SQL> create database link to_db11g connect to charis identified by charis using 'DB11G';
Database link created.
SQL> drop public database link to_prod4 ;
Database link dropped.
SQL>
SQL> create database link to_prod4 connect to gaok identified by gaok using 'PROD4';
Database link created.
SQL>
SQL> insert into charis.cha_tt@to_db11g select * from gaok.t_prod4@to_prod4;
A库12.1.0.2
B库12.1.0.2
C库11.2.0.4
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/23850820/viewspace-2065503/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/23850820/viewspace-2065503/