Refreshing Changed Db Link Source (oracle Gateway To Sql Server)

the question is pretty straightforward, - when I chance to change setting in oracle gateway to microsoft sql server (dg4msql) configuration (HS_FDS_CONNECT_INFO) to another databas

Solution 1:

Database links are kept open for the duration of a session. The gateway makes use of a database link so it is logical to state that if you change a gateway config, in order for it to be activated, you need to re-open the link.

Easiest is to stop and start the sessions but this can also be done by issuing an

alter systemclose database link linkname

See Closing Database Links in the docu.