dblink 创建 和 用户解锁

ALTER USER CAT_SDV3 ACCOUNT UNLOCK;


grant connect,resource ,unlimited tablespace to cat_sdv3;




create public database link dblink_ngcat connect to catdb identified by catdb123456 using'(DESCRIPTION=  
(ADDRESS_LIST=  
(ADDRESS=(PROTOCOL=TCP)(HOST=10.71.193.249)(PORT=1521))  
)  
(CONNECT_DATA=  
(SERVICE_NAME= portalnext)  
)  
)';