今天通过数据链路将远程用户下的表导入本地时,遇到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 us