您的位置: 首页 > 文章 > oracle db link

oracle db link

分类: 文章 • 2022-09-09 20:56:06

一、 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;