今天通过数据链路将远程用户下的表导入本地时，遇到ORA-39149: 无法将授权用户链接到非授权用户C:Usersdmingt;expdp admin/a
今天通过数据链路将远程用户下的表导入本地时，，遇到ORA-39149: 无法将授权用户链接到非授权用户
C:Usersdmin>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:Usersdmin>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:DUMPDB1.DMP
作业 “ADMIN”.”SYS_EXPORT_SCHEMA_10″ 已于 10:31:47 成功完成
版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容， 请发送邮件至253000106@qq.com举报，一经查实，本站将立刻删除。
发布者：PHP中文网，转转请注明出处：https://www.chuangxiangniao.com/p/1925349.html
