ORA-01031: insufficient privileges while creating a database link

Problem:

While creating a database link, the user is getting insufficient privileges error:

SQL> create database link ASCP_TO_PROD connect to apps_ro identified by apps_ro using 'PROD';

ORA-01031: insufficient privileges while creating a database link


Fix:

SQL> alter session set current_schema = APPS_RO;

Session altered.

SQL> create database link ASCP_TO_PROD connect to apps_ro identified by apps_ro using 'PROD';

Database link created.