AnsweredAssumed Answered

Data warehouse DBlink issue

Question asked by shiva.s43 on Nov 2, 2015
Latest reply on Nov 10, 2015 by shiva.s43

Hi,

 

I am getting error in CSA data warehouse page while adding dblink details.

Initially I tried from CSA a to create link but it failed. Then I created the Link in SQL developer and used the link name in CSA but not fixed.

 

The clarity and DWH schema are in two different host. The link is working fine. I can run the query on clarity tables from DWH schema/user. The DWH user has all the rights granted.

Data Warehouse Database Link Config QueryI tried solution mentioned in this thread but no help.

 

I have attached the NSA.log and other screenshot. Please suggest what could be the issue.

 

Thanks,
Shiva

Attachments

Outcomes