Skip to Content
0
Former Member
Oct 20, 2009 at 12:25 PM

Getting Error - DBIF_DSQL2_SQL_ERROR - ORA-02019: connection description

119 Views

Hi,

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,

Neethu Mohan