oracle db link

一、 Create database link

createpublicdatabaselink TO_XXX

  connectto userObj

  using'(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = XX.XX.XX.XX)(PORT= 1526)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME =XX)))';

 

说明：

• userObj是一个用户

 

二、Create the user

createuser userObj

  identifiedby ""

  defaulttablespace  XX

  passwordexpire

-- Grant/Revoke system privileges

三、使用dblink

SELECT * FROM table_name@ TO_XXX;