ORA-31631: privileges are required-ORA-39149: cannot link privileged user to non-privileged user

Cause:

If we use network link for import of objects from source to destination, error thrown due to lack of privileges

[oracle@orcl19x ~]$ impdp \'/ as sysdba\' directory=exp dumpfile=NL_TEST.dmp logfile=NL_TEST.log tables=TEST.TABX table_exists_action=replace network_link=EXDBX metrics=YES

Import: Release 12.1.0.2.0 - Production on Mon Aug 16 16:07:56 2021

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
ORA-31631: privileges are required
ORA-39149: cannot link privileged user to non-privileged user

Workaround:

Grant the privileges required for import of objects using database links to source database

kish@exdbx<>grant imp_full_database,exp_full_database to TEST;

Grant succeeded.

Elapsed: 00:00:00.14

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s