OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » sql loader (oracle 10.1.0.2.0 on IBM AIX 5.2 )

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

sql loader [message #439378]

Sat, 16 January 2010 01:50

oradba123
Messages: 86
Registered: June 2009
Location: india

Member

Hi,

i have csv files to which i want to load the csv file dataand table structure in oracle. my csv files on the window machine but database is runing on ibm aix.so how to do it please any one can help me about. thanks a lot in advance

i know th syntax below

$sqlldr userid=username/password control=<filename> log=<log filename>

Report message to a moderator

Re: sql loader [message #439381 is a reply to message #439378]

Sat, 16 January 2010 02:13

Michel Cadot
Messages: 68634
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Apart the connection string should be "user/password@service_name_from_tnsnames", have you any problem with it?

Regards
Michel

Report message to a moderator

Re: sql loader [message #439388 is a reply to message #439381]

Sat, 16 January 2010 02:44

oradba123
Messages: 86
Registered: June 2009
Location: india

Member

HI michel,

thnaks for quick response but can i give .csv extension instead of .ctl like below

$ sqlldr userid=username/password@servicename control=xyz.csv log=x.log

is it correct will it accept .csv extention.thanks again

Report message to a moderator

Re: sql loader [message #439389 is a reply to message #439378]

Sat, 16 January 2010 02:44

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

The fact that the CSV file is on your (client) PC and the database is on a (remote) server, shouldn't bother you. SQL*Loader runs successfully on the client computer - you just have to specify the connect string (as pointed out by Michel in the previous message).

Report message to a moderator

Re: sql loader [message #439396 is a reply to message #439388]

Sat, 16 January 2010 03:23

Michel Cadot
Messages: 68634
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

is it correct will it accept .csv extention.thanks again

Generally speaking, Oracle does not care about extension, it takes the full name. You can call a control file .csv if you want, the important is that its content matches a control file.
This is the same thing for the data file, you can name it as you want but its content must match the description you made in the conntrol file.

Regards
Michel

Report message to a moderator

Re: sql loader [message #439402 is a reply to message #439388]

Sat, 16 January 2010 03:33

flyboy
Messages: 1903
Registered: November 2006

Senior Member

oradba123 wrote on Sat, 16 January 2010 09:44

can i give .csv extension instead of .ctl like below

$ sqlldr userid=username/password@servicename[/email] control=xyz.csv log=x.log

Extension does not matter. The content does. So, if xyz.csv is valid sqlldr control file, it should be executed correctly. If no, you shall create yourself, as described e.g. here. Detailed description is available in Utilities book, available with other Oracle documentation e.g. online on http://tahiti.oracle.com/ (this documentation pages seem to be inaccessible now; anyway you may search for other page(s) with this content or wait for their availability).

Report message to a moderator