How can I transfer data from a SQL table to an Oracle table?

I have a _Users_ table in MS SQL Server, then I created the same table in Oracle. How I can retrieve data from SQ开发者_如何转开发L table to my new Oracle table? Thanks.

See this blog post, there is discussed how to use heterogeneous services and example of how to retrieve data in oracle from sql server:

http://geogeeks.net/2011/01/28/oracle-heterogeneous-serviceshsodbc/

Query data from sql server and insert into oracle table via database link... First of all see the above blog.

What version or Oracle? Is it MS SQL Server or My Sql? You can take a look at Hetrogenous Services which involves:

• Install ODBC
• Setup tnsnames.ora for odbc connectivity (authentication=none)
• Create db-link

Also, this is a useful link regarding this topics.

Multiple migration tools are available which are specifically made for migrating data from database to database. In your case i would suggest Keeptool. It has import and export facility to transfer/migrate data. Here is a link to keeptool http://www.keeptool.com/index_en.php