create database link linkname connect to user identified by usrpwd using 'demona';//demona为用net8 easy config创建的连接字符串 目的方数据库的init.ora文件中的global_names设为falsecreate table tb as select * from ta@linkname;
通过sql plus 建立dblink 肯定可以的, 你要去动手去尝试不去尝试光等着别人给你答案,怎么可能呢。去尝试了以后有问题,你再问
SQL> select * from t_kfqy_jbqk@linkfdc; select * from t_kfqy_jbqk@linkfdc * 错误位于第1行: ORA-12154: TNS:could not resolve service name
connect to user
identified by usrpwd
using 'demona';//demona为用net8 easy config创建的连接字符串
目的方数据库的init.ora文件中的global_names设为falsecreate table tb as select * from ta@linkname;
select * from t_kfqy_jbqk@linkfdc
*
错误位于第1行:
ORA-12154: TNS:could not resolve service name