Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

creating a heterogeneous data source, so I can query a MS SQL Server database from within Oracle

2621671Aug 19 2014 — edited Aug 20 2014

Hi all,

How do I create a heterogeneous data source, so I can query a MS SQL Server database from within Oracle.

begin

insert into oracle_table (column1)

select column1 from heterogeneous_ms_sql_table;

commit;

end;

Is it possible at all?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 17 2014
Added on Aug 19 2014
3 comments
1,275 views