I am accessing a view in DWH system using EXEC ENDEXEC statements and getting the error as mentioned in the subject.
The Oracle error description is
ORA-02019: connection description for remote database not found.
The DB link is given in the format OPS$SMART@VIEW_NAME@dblink.
I think the link name is correct . Is there any other was I can check if the connection is established between the DWH and SAP system?
Any pointers will be appreciated.
Thanks in advance,