Home » RDBMS Server » Server Utilities » sql loader (oracle 9.2.0.3 ,XP)
sql loader [message #407103] Mon, 08 June 2009 08:12 Go to next message
prachij593
Messages: 266
Registered: May 2009
Senior Member
I need to load the data from .csv to a table in my oracle database. I want to know where the control files needs to be (the path)? is it the server path??
I am using oracle client sqlplus.
Re: sql loader [message #407111 is a reply to message #407103] Mon, 08 June 2009 08:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I want to know where the control files needs to be (the path)?

Anywhere accessible from where you execute SQL*Loader.

Quote:
I am using oracle client sqlplus.

SQL*Loader has nothing to do with SQL*Plus.

Regards
Michel
Re: sql loader [message #407114 is a reply to message #407111] Mon, 08 June 2009 08:50 Go to previous messageGo to next message
prachij593
Messages: 266
Registered: May 2009
Senior Member
Can I do it from any specified path in my machine. The Oracle database is in Unix.


In DBARTISAN there is an option Import file where I have to select the csv source,the database and the target table. Map the columns and import.This way it generates insert statements.
I ran the dml as a batch.

Will the load with sqlloader be fast in comparison to this approach?

One more concern when I tried to open the csv file it shows that
there are more than limited no. of rows execel can hold.
I am seeing 65536 in execel sheet. But while importing the data from the same csv files using Import file option in Dbartisan I am seeing more than 2 million rows.

Re: sql loader [message #407119 is a reply to message #407103] Mon, 08 June 2009 09:27 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>One more concern when I tried to open the csv file it shows that there are more than limited no. of rows execel can hold.

Upgrade to the latest version of Excel.
Re: sql loader [message #407124 is a reply to message #407114] Mon, 08 June 2009 09:55 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Will the load with sqlloader be fast in comparison to this approach?

Far much faster.

Regards
Michel
Re: sql loader [message #407126 is a reply to message #407124] Mon, 08 June 2009 10:03 Go to previous messageGo to next message
prachij593
Messages: 266
Registered: May 2009
Senior Member
Thanks...
The oracle database is in unix server
And client m/c is XP and using oracle client.

Can I do sqlloader from command line ? user/passwrd@oracledatabasenme control=temp.ctl log=temp.log bad=temp.bad errors=100000000 data=temp.csv
Re: sql loader [message #407128 is a reply to message #407103] Mon, 08 June 2009 10:09 Go to previous message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>Can I do sqlloader from command line ?
What happened when you tried to do so?
Previous Topic: sqlldr help needed
Next Topic: sqlldr parallel jobs
Goto Forum:
  


Current Time: Fri Dec 09 06:09:51 CST 2016

Total time taken to generate the page: 0.09744 seconds