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: 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
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: 68617
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: 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:
  


Current Time: Tue Mar 19 01:14:40 CDT 2024