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