ORA-39149: 无法将授权用户链接到非授权用户


今天通过数据链路将远程用户下的表导入本地时，遇到ORA-39149: 无法将授权用户链接到非授权用户
 
C:\Users\admin>expdp admin/admin network_link=ADMIN_TO_DB1 directory=mydir dumpf
ile=db1.dmp logfile=db1.log include=table:\"in ('T','T1','T2','T3')\"
Export: Release 11.2.0.1.0 - Production on 星期二 7月 10 10:27:13 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Produc
tion
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-31631: 需要权限
ORA-39149: 无法将授权用户链接到非授权用户
 
检查Oracle的错误手册：
ORA-39149: cannot link privileged user to non-privileged user
Cause: A Data Pump job initiated be a user with EXPORT_FULL_DATABASE/IMPORT_FULL_DATABASE roles specified a network link that did not correspond to a user with equivalent roles on the remote database.
Action: Specify a network link that maps users to identically privileged users in the remote database
 
解决办法：
授予db1 exp_full_database 权限
 
[oracle@cdc1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Tue Jul 10 10:35:19 2012
Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> grant exp_full_database to db1;
Grant succeeded.
 
C:\Users\admin>expdp admin/admin network_link=ADMIN_TO_DB1 directory=mydir dumpf
ile=db1.dmp logfile=db1.log include=table:\"in ('T','T1','T2','T3')\"
Export: Release 11.2.0.1.0 - Production on 星期二 7月 10 10:31:09 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Produc
tion
With the Partitioning, OLAP, Data Mining and Real Application Testing options
启动 "ADMIN"."SYS_EXPORT_SCHEMA_10":  admin/******** network_link=ADMIN_TO_DB1 d
irectory=mydir dumpfile=db1.dmp logfile=db1.log include=table:"in ('T','T1','T2'
,'T3')"
正在使用 BLOCKS 方法进行估计...
处理对象类型 SCHEMA_EXPORT/TABLE/TABLE_DATA
使用 BLOCKS 方法的总估计: 248.0 MB
处理对象类型 SCHEMA_EXPORT/TABLE/TABLE
. . 导出了 "DB1"."T1"                                  82.92 KB   10000 行
. . 导出了 "DB1"."T"                                   10.37 KB       1 行
已成功加载/卸载了主表 "ADMIN"."SYS_EXPORT_SCHEMA_10"
******************************************************************************
ADMIN.SYS_EXPORT_SCHEMA_10 的转储文件集为:
  D:\DUMP\DB1.DMP
作业 "ADMIN"."SYS_EXPORT_SCHEMA_10" 已于 10:31:47 成功完成

相关内容