创建与oracle 9i的数据库链接

Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 

Connected as scott@ORCL9

 

SQL> create database link dblink_rfid connect to "rfid" identified by "rfid" using "rfid";

 

create database link dblink_rfid connect to "rfid" identified by "rfid" using 'rfid'

 

ORA-02010: 缺失主机连接字符串

 出错的原因在于  最后的应该用单引号，如果11版本 前者的密码与后者的用户名可以什么都不用。这里是因为9I版本的BUG，若不用双引号括起来，会把密码和用户名转成大写引起错误。

SQL> create database link dblink_rfid connect to "rfid" identified by "rfid" using 'rfid';

 

Database link created

 

SQL> select * into m_transform_tag from m_transform_tag@dblink_rfid;

 

select * into m_transform_tag from m_transform_tag@dblink_rfid

 

ORA-00905: 缺失关键字

 oracle 与 sqlserver 用其他表数据创建表的不同之处。sqlserver用select * into,而oracle用create table xxx as select * from 

SQL> create table m_transform_tag as select * from m_transform_tag@dblink_rfid;

 

Table created

 

SQL> select count(*) from m_transform_tag;

 

  COUNT(*)

----------

    713782