Home » Open Source » MySQL » Import SQL table in Oracle (SQL - 2008 - Windows 7, Oracle 10 G - Windows 2008)
Import SQL table in Oracle [message #569562] Mon, 29 October 2012 11:07 Go to next message
rahul1982
Messages: 31
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
Re: Import SQL table in Oracle [message #569564 is a reply to message #569562] Mon, 29 October 2012 11:13 Go to previous messageGo to next message
Michel Cadot
Messages: 59105
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Import SQL table in Oracle [message #576925 is a reply to message #569564] Sun, 10 February 2013 21:31 Go to previous messageGo to next message
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.
Re: Import SQL table in Oracle [message #576930 is a reply to message #576925] Sun, 10 February 2013 22:35 Go to previous message
BlackSwan
Messages: 22783
Registered: January 2009
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:
  


Current Time: Wed Sep 17 07:31:35 CDT 2014

Total time taken to generate the page: 0.11614 seconds