今天通过数据链路将远程用户下的表导入本地时，遇到ora-39149: 无法将授权用户链接到非授权用户c:\users\admingt;expdp admin/a
今天通过数据链路将远程用户下的表导入本地时，，遇到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 成功完成