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;