OraFAQ Forum: Server Utilities » Need to load .csv file into Oracle table.

Home » RDBMS Server » Server Utilities » Need to load .csv file into Oracle table.

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

Need to load .csv file into Oracle table. [message #226023]

Thu, 22 March 2007 05:50

yugamore
Messages: 23
Registered: December 2006

Junior Member

Hi,
I have a .csv file with 40 million records. I need to load this file into oracle table. But I canot use sql loader to do this ,because I don't have access to unix. Can I load this file using some tool like Toad or Pl/sql developer? How can i do it faster?

Report message to a moderator

Re: Need to load .csv file into Oracle table. [message #226024 is a reply to message #226023]

Thu, 22 March 2007 05:57

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>because I don't have access to unix
You can use sqlldr from any available client in any compatible OS.
Using sqlldr direct load. Make yourlife a little easier.
Else, look into UTL_FILE/external tables (both will need access to the server, if the server is in UNIX??).
Else use Java methods to read the file line-by-line...trouble.

Report message to a moderator

Re: Need to load .csv file into Oracle table. [message #226042 is a reply to message #226024]

Thu, 22 March 2007 07:07

yugamore
Messages: 23
Registered: December 2006

Junior Member

Can I run sql loader using Pl/sql developer? If Yes how can I do it?

Report message to a moderator

Re: Need to load .csv file into Oracle table. [message #226046 is a reply to message #226042]

Thu, 22 March 2007 07:16

Frank
Messages: 7901
Registered: March 2000

Senior Member

No.
Run it from your command line.

Report message to a moderator

Re: Need to load .csv file into Oracle table. [message #232507 is a reply to message #226023]

Fri, 20 April 2007 15:02

ejboy
Messages: 2
Registered: April 2007

Junior Member

Here is a simple example on how to load CSV file into a table using Scriptella, a Java-based open source ETL Tool:
http://snippets.dzone.com/posts/show/3508

Report message to a moderator

Re: Need to load .csv file into Oracle table. [message #232508 is a reply to message #226023]

Fri, 20 April 2007 15:14

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Responding to a post that is almost ONE month old might be a waste of electrons & finger motions.

Report message to a moderator

Re: Need to load .csv file into Oracle table. [message #232514 is a reply to message #232508]

Fri, 20 April 2007 15:44

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

But a nice useful method nevertheless.

Report message to a moderator

Re: Need to load .csv file into Oracle table. [message #232570 is a reply to message #232508]

Sat, 21 April 2007 05:52

ejboy
Messages: 2
Registered: April 2007

Junior Member

I see similar questions repeating in different forums from time to time, so I've put a link to Scriptella example to help other people looking for typical ETL solutions. It's frustrating when you google for something and find a question without different ways to achieve the goal.
P.S. I've forgotten to mention that Scriptella has no limitation on the number of CSV records being processed, provides JMX-based monitoring in real time and can be easily executed from a command line, Ant or even directly from a Java code.

[Updated on: Sat, 21 April 2007 05:55]

Report message to a moderator

Previous Topic:	SQL*LOADER Error
Next Topic:	Oracle Import

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 11:31:49 CST 2024