本文共 1242 字,大约阅读时间需要 4 分钟。
如果用普通用户,如果没授权,是无法建立dblink的:
[oracle@oracle000 ~]$ sqlplus gao/gao[uniread] Loaded history (10 lines)SQL*Plus: Release 11.2.0.3.0 Production on 木 10月 17 09:30:27 2013Copyright (c) 1982, 2011, Oracle. All rights reserved.Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsに接続されました。SQL> create database link gaolink connect to gao identified by gao using 'mydb'; create database link gaolink connect to gao identified by gao using 'mydb'; create database link gaolink connect to gao identified by gao using 'mydb' *行1でエラーが発生しました。:ORA-01031: 権限が不足しています。SQL>
如果以sysdba身份则可以建立dblink:
===============================================================================[oracle@oracle000 ‾]$ sqlplus / as sysdba[uniread] Loaded history (13 lines)SQL*Plus: Release 11.2.0.3.0 Production on 木 10月 17 14:17:58 2013Copyright (c) 1982, 2011, Oracle. All rights reserved.Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsに接続されました。SQL> create database link gaolink connect to gao identified by gao using 'mydb'; データベース・リンクが作成されました。SQL>
转载地址:http://zyhcx.baihongyu.com/