Data Base Link creation and deletion

• To check the existing Database Links

        SELECT * 

          FROM USER_DB_LINKS;

• To create Database Link

        CREATE DATABASE LINK xx_db_link

        CONNECT TO apps IDENTIFIED BY apps

        USING '(DESCRIPTION=

        (ADDRESS=(PROTOCOL=tcp)(HOST=<<XX_HOST>>)(PORT=1234))

        (CONNECT_DATA=

        (SID=ABC)

        )

        )';

• To Drop the Database Link

        DROP DATABASE LINK xx_db_link;