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


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 - 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 - 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


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