ORA-39149: unable to link authorized users to unauthorized users

Source: Internet
Author: User
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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.