I have been able to create a database link to an ODBC link, spaload_dev, which points to a SQL Server database. These are the entries in listener.ora and initdg4odbc.ora:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = D:\OracleDB64\product\11.2.0\dbhome_2)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:D:\OracleDB64\product\11.2.0\dbhome_2\bin\oraclr11.dll")
)
(SID_DESC=
(SID_NAME=spaload_dev)
(ORACLE_HOME=D:\OracleDB64\product\11.2.0\dbhome_2)
(PROGRAM=dg4odbc)
)
)
HS_FDS_CONNECT_INFO = spaload_dev
HS_FDS_TRACE_LEVEL = OFF
I want to create another database link to a different ODBC link which I am calling spaload_stg. This ODBC link points to a different server than the first link. How do I do that? Can there be comma separated entries for HS_FDS_CONNECT_INFO, i.e.:
HS_FDS_CONNECT_INFO = spaload_dev, spaload_stg?
Thanks.