|
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 用其他表數(shù)據(jù)創(chuàng)建表的不同之處。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
|
|
|
