CODEWITHSUNDEEP
sql-serveroracle-databasegatewaydblink
hello_earth
hello_earth

Reputation: 1562

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 database on the same server, the database link does not always gets refreshed - sometimes new selects using that database link stay hooked to the old setting. probably oracle gateway caches the connection settings in some way? how do I clear the cache? thanks

Upvotes: 0

Views: 3883

Answers (1)

user123664
user123664

Reputation:

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 system close database link linkname

See Closing Database Links in the docu.

Upvotes: 1

Related Questions