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!

Create and insert into table from Oracle to MS SQL server.

VJ4Feb 3 2011 — edited Feb 3 2011

Hello,
Oracle Database 11g and Red hat 5

I have a very different kind of issue. I am handling the ORACLE db(remote db with all the important data). On the other side their is a MS SQL server db(local db with some testing data in it). All the users will access the ORACLE db for the actual processing but for sometime they need to apply some of their own concepts. So they will transfer the data from ORACLE to MS sql server.

I want to create a code in ORACLE db like a procedure , which will create a table in MS sql server , insert data into it,Also create some metadata table to keep some of my table's info on MS SQL serve db,If the table is present it should append the data, .... like many things ...

Overall my question is , how can i write a code to make these operation on a remote db, that to these operations are DDL and on MS SQL Server(Non-Oracle) ???

Please guide me with some ideas or solutions ...
Also provide if you have some good links to study ...

thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 3 2011

Added on Feb 3 2011

#general-database-discussions

2 comments

308 views