OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » sql loader (oracle 9.2.0.3 ,XP)

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

sql loader [message #407103]

Mon, 08 June 2009 08:12

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.

Report message to a moderator

Re: sql loader [message #407111 is a reply to message #407103]

Mon, 08 June 2009 08:38

Michel Cadot
Messages: 68645
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

Report message to a moderator

Re: sql loader [message #407114 is a reply to message #407111]

Mon, 08 June 2009 08:50

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.

Report message to a moderator

Re: sql loader [message #407119 is a reply to message #407103]

Mon, 08 June 2009 09:27

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: sql loader [message #407124 is a reply to message #407114]

Mon, 08 June 2009 09:55

Michel Cadot
Messages: 68645
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

Report message to a moderator

Re: sql loader [message #407126 is a reply to message #407124]

Mon, 08 June 2009 10:03

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

Report message to a moderator

Re: sql loader [message #407128 is a reply to message #407103]

Mon, 08 June 2009 10:09

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Can I do sqlloader from command line ?
What happened when you tried to do so?

Report message to a moderator

Previous Topic:	sqlldr help needed
Next Topic:	sqlldr parallel jobs

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 11:03:26 CDT 2024