OraFAQ Forum: MySQL » Import SQL table in Oracle

Home » Open Source » MySQL » Import SQL table in Oracle (SQL - 2008 - Windows 7, Oracle 10 G - Windows 2008)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Import SQL table in Oracle [message #569562]

Mon, 29 October 2012 11:07

rahul1982
Messages: 53
Registered: November 2011
Location: Pune

Member

Hi,

I have a table in SQL Server 2008 which is having total "53504872" records.

As per the project requirement, I need to import this table in Oracle 10g. I tried to google but not getting exact stpes.

Kindly suggest.

Regards,
Rahul

Report message to a moderator

Re: Import SQL table in Oracle [message #569564 is a reply to message #569562]

Mon, 29 October 2012 11:13

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

So you have SQL Server table and want to import it in Oracle database and post this in a MySQL forum... the answer is in a DB2 forum. Twisted Evil

Quote:

I tried to google but not getting exact stpes.

You didn't search very well (of course if you searched in Postgres forums I understand you didn't find anything).
Spool your table in a CSV file and use SQL*Loader (or to load it into Oracle table).

Regards
Michel

Report message to a moderator

Re: Import SQL table in Oracle [message #576925 is a reply to message #569564]

Sun, 10 February 2013 21:31

dia.william923@gmail.com
Messages: 5
Registered: February 2013

Junior Member

You can convert the contents of your table in CSV file format using PL/SQL or UTIL_FILE library. And if you are a DBA then you can use the Export utility to import table in to binary format.

Report message to a moderator

Re: Import SQL table in Oracle [message #576930 is a reply to message #576925]

Sun, 10 February 2013 22:35

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Please refrain from resurrecting dormant threads.
OP has not visited this forum this year.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

[Updated on: Sun, 10 February 2013 22:36]

Report message to a moderator

Previous Topic:	Raise Exception
Next Topic:	MySQL Cluster

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 02 17:34:53 CST 2025