ORA-39149: unable to link authorized users to unauthorized users C: Usersadmingt; expdpadmina
ORA-39149: unable to link authorized Users to unauthorized Users C: \ Users \ admingt; expdp admin/
Today, when you import a table from a remote user to a local through a data link, you encounter a ORA-39149: unable to link the authorized user to an unauthorized user
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 Tuesday July 10 10:27:13 2012
Copyright (c) 1982,200 9, Oracle and/or its affiliates. All rights reserved.
Connect to: 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: requires Permissions
ORA-39149: unable to link authorized users to unauthorized users
Check Oracle error manual:
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
Solution:
Grant db1 exp_full_database Permissions
[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,200 9, Oracle. All rights reserved.
Connected:
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 Tuesday July 10 10:31:09 2012
Copyright (c) 1982,200 9, Oracle and/or its affiliates. All rights reserved.
Connect to: 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
Start "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 ')"
Using the BLOCKS Method for estimation...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using the BLOCKS method: 248.0 MB
Processing object type SCHEMA_EXPORT/TABLE
.. Exported "DB1". "T1" 82.92 KB 10000 rows
.. Exported "DB1". "T" 10.37 KB 1 line
The master table "ADMIN". "SYS_EXPORT_SCHEMA_10" is successfully loaded/uninstalled"
**************************************** **************************************
The dump file set of ADMIN. SYS_EXPORT_SCHEMA_10 is:
D: \ DUMP \ DB1.DMP
The job "ADMIN". "SYS_EXPORT_SCHEMA_10" was successfully completed at 10:31:47.