How to Create a Database Link in Another User’s Schema

Login as SYSDBA

bash-3.2$ sqlplus '/as sysdba'

1               1)     Give Grant to the User where the Database Link has to be created

                        GRANT CREATE DATABASE LINK TO xapps WITH ADMIN OPTION;

2               2)     Login to the User and create the same

       CREATE DATABASE LINK xprod11i

                 CONNECT TO apps IDENTIFIED  BY apps

                 USING '10.10.52.5:1524/prod'