Hello
I am trying to connect database link in APEX to oracle 11g database. I am filling relevant details still i am getting insufficient privileges error everytime tried almost everything available on internet but still unable to resolve.
However when i tried to create database link through sqlplus i am able to create db link successfully but unable to user it.
Following is the configration from TNSNames.ora file
DEEP =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT\_DATA =
(SERVER = DEDICATED)
(SERVICE\_NAME = deep)
)
)