创建一个db link,语法如下: CREATE [PUBLIC] DATABASE LINK <link_name> CONNECT TO <user_name> IDENTIFIED BY <password> USING '<service_name>'; 例如: CREATE DATABASE LINK local CONNECT TO hr IDENTIFIED BY hr USING 'local';然后即可以在sql中使用这个link SELECT table_name, tablespace_name FROM user_tables@local;
CREATE [PUBLIC] DATABASE LINK <link_name>
CONNECT TO <user_name>
IDENTIFIED BY <password>
USING '<service_name>';
例如:
CREATE DATABASE LINK local
CONNECT TO hr IDENTIFIED BY hr
USING 'local';然后即可以在sql中使用这个link SELECT table_name, tablespace_name FROM user_tables@local;