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 成功完成