Home » RDBMS Server » Server Utilities » sql loader (oracle 10.1.0.2.0 on IBM AIX 5.2 )
sql loader [message #439378] Sat, 16 January 2010 01:50 Go to next message
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>

Re: sql loader [message #439381 is a reply to message #439378] Sat, 16 January 2010 02:13 Go to previous messageGo to next message
Michel Cadot
Messages: 63807
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
Re: sql loader [message #439388 is a reply to message #439381] Sat, 16 January 2010 02:44 Go to previous messageGo to next message
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
Re: sql loader [message #439389 is a reply to message #439378] Sat, 16 January 2010 02:44 Go to previous messageGo to next message
Littlefoot
Messages: 20827
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).
Re: sql loader [message #439396 is a reply to message #439388] Sat, 16 January 2010 03:23 Go to previous messageGo to next message
Michel Cadot
Messages: 63807
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
Re: sql loader [message #439402 is a reply to message #439388] Sat, 16 January 2010 03:33 Go to previous messageGo to next message
flyboy
Messages: 1831
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).
Re: sql loader [message #439404 is a reply to message #439396] Sat, 16 January 2010 04:15 Go to previous messageGo to next message
oradba123
Messages: 86
Registered: June 2009
Location: india
Member




this is the microsoft excel sheet file to download in oralce
Re: sql loader [message #439407 is a reply to message #439404] Sat, 16 January 2010 04:32 Go to previous message
Michel Cadot
Messages: 63807
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
First save it in csv format.

Regards
Michel
Previous Topic: i have problem
Next Topic: ora-01536 when importing
Goto Forum:
  


Current Time: Wed Sep 28 10:51:10 CDT 2016

Total time taken to generate the page: 0.11753 seconds