Home » SQL & PL/SQL » SQL & PL/SQL » How to load excel file in SQL Loader? (oracle 10g)
How to load excel file in SQL Loader? [message #326320] Wed, 11 June 2008 01:44 Go to next message
kathiresan.c
Messages: 23
Registered: February 2008
Location: Tamil Nadu, India
Junior Member
Hi Friends,

I have much data in MS-Excel file... I have to read all data and insert into particular table..

I tried with pl/sql program.. but it is bad thing to insert lot of data by pl/sql program.. because of performance issue..

So i heard about the SQL loader..

I don't know anything about SQL Loader ..

So Can u please help me How to insert a huge records through SQL loader? ( i am Using Oracle 10g version)

Thanks in Advance!!!
Re: How to load excel file in SQL Loader? [message #326322 is a reply to message #326320] Wed, 11 June 2008 01:48 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Save CSV -> SQl*Loader/external table.

Search, this has been answered about a zillion times.
All Oracle documentation including about the 2 mentioned points is on http://tahiti.oracle.com

Regards
Michel

[Updated on: Wed, 11 June 2008 01:49]

Report message to a moderator

Re: How to load excel file in SQL Loader? [message #326325 is a reply to message #326320] Wed, 11 June 2008 01:50 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>.I don't know anything about SQL Loader ..
just google.

This might be a good start.
http://www.orafaq.com/wiki/SQL*Loader_FAQ

>> but it is bad thing to insert lot of data by pl/sql program
Define 'a lot'.
A million? A Billion? Sqlldr direct load works in most cases.
For much lower volume and comple manipulations, external table might be a good alternative. It depends on your need.
Re: How to load excel file in SQL Loader? [message #326358 is a reply to message #326325] Wed, 11 June 2008 03:33 Go to previous messageGo to next message
kathiresan.c
Messages: 23
Registered: February 2008
Location: Tamil Nadu, India
Junior Member
Hi friends,

What are the steps to be need for run sql loader?

Here i created data file

The data file path is :

d:\csvfile\sample.csv

Following steps i have done :

in command line :

sqlldr username@server/password control=loader.ctl

here i am getting the error is

-0734: unknown command beginning "sqlldr ssi..." - rest of line ignored.

What is problem here?

Still i am not created loader.ctl file..

Whether loader.ctl is in someohter location or direclty write after the sqlldr command is executed.. if loader.ctl file is in some other loaction means how to set path?

Re: How to load excel file in SQL Loader? [message #326360 is a reply to message #326358] Wed, 11 June 2008 03:39 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
sqlldr is an OS command not a SQL*Plus one.

Regards
Michel
Re: How to load excel file in SQL Loader? [message #326430 is a reply to message #326358] Wed, 11 June 2008 07:36 Go to previous messageGo to next message
joy_division
Messages: 4641
Registered: February 2005
Location: East Coast USA
Senior Member
kathiresan.c wrote on Wed, 11 June 2008 04:33

Still i am not created loader.ctl file..



You have not created the loader.ctl file? I think you need to go back and read the links and documentation again.
Re: How to load excel file in SQL Loader? [message #326432 is a reply to message #326430] Wed, 11 June 2008 07:49 Go to previous message
Olivia
Messages: 519
Registered: June 2008
Senior Member
Go through the link :

http://www.orafaq.com/wiki/SQL*Loader_FAQ

Mahesh has already wrote in his reply.



Regards,
Oli

[Updated on: Wed, 11 June 2008 07:52]

Report message to a moderator

Previous Topic: Default tables and data from scott schema required
Next Topic: Case Expression used in Select Statement
Goto Forum:
  


Current Time: Tue Dec 06 15:55:42 CST 2016

Total time taken to generate the page: 0.30288 seconds