一定记得修改 init.ora # Global Naming -- enforce that a dblink has same name as the db it connects to global_names = false
database link 建立成功后,就可以查询另一数据库的数据,方法如black_snail(●龙飞虎○) 所示,这也就实现了数据库之间的数据互传了.要拷贝另一数据库的数据,可以: create table table_name as select * from table_name@CACA; 或者 insert into table_name select * from table_name@CACA; 但要注意:如果database link与要连接的数据库不同名,则要修改 init.ora如 Parkinson(无欲无求所示: # Global Naming -- enforce that a dblink has same name as the db it connects to global_names = false 要不然会报错.
# Global Naming -- enforce that a dblink has same name as the db it connects to
global_names = false
create table table_name as select * from table_name@CACA; 或者
insert into table_name select * from table_name@CACA;
但要注意:如果database link与要连接的数据库不同名,则要修改 init.ora如 Parkinson(无欲无求所示:
# Global Naming -- enforce that a dblink has same name as the db it connects to
global_names = false
要不然会报错.