Oracle 同义词的创建

创建public dblink 。

createpublicdatabaselinktest_link
connecttocsservicedbidentifiedbyhuawei123
using'(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.119)(PORT=1521))
)
(CONNECT_DATA=
(SERVICE_NAME=orcl)
)
)';
Databaselinkcreated.

SQL>desccs_user;
ERROR:
ORA-04043:objectcs_userdoesnotexist


SQL>desccs_user@test_link;
Name					Null?Type
-----------------------------------------------------------------------------
PK_BUR_USERID				NOTNULLVARCHAR2(18)
BUR_USER_FLAG				NOTNULLVARCHAR2(32)

select*fromdba_objectswhereobject_type='DATABASELINK';
selectowner,db_linkfromdba_db_links;--查看dblink的owner及link名字

删除dblink 。

SQL>DROPPUBLICDATABASELINKcsmain;
Databaselinkdropped.
SQL>DROPPUBLICDATABASELINKcsserver;
Databaselinkdropped.
SQL>

如果语句中不加public，则创建的owner就是现连接的用户 。

SQL>createdatabaselinkCSMAIN
connecttocsmaindbidentifiedbyhuawei123
using'(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.119)(PORT=1521))
)
(CONNECT_DATA=
(SERVICE_NAME=orcl)
)
)';
SQL>selectowner,db_linkfromdba_db_links;
OWNERDB_LINK
---------------------------------------------
CS_AUXCSMAIN
CS_AUXCSSERVER

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!