Erman Arslan's Oracle Forum › Database

Dblink from Linux to windows

Classic

List

Threaded

2 messages Options

satish

Dblink from Linux to windows

Dear erman,

Is it possible to create dblink from oracle database running on rhel 7 to non oracle database running on windows?

Any links for reference.

Thanks,
SG

ErmanArslansOracleBlog

Re: Dblink from Linux to windows

Administrator

Yes. It is possible. But the method changes according to the target database vendor.
Basically you will use the Heteregenous Gateway.
You can read the related documentation..
Here is a blog post for the reference;

https://ermanarslan.blogspot.com/2016/01/rdbms-oracle-to-sqlserver-dblink.html

This is for "Sql server to Oracle" db link, but the mehtodology is similar for other databases as well.