Home » RDBMS Server » Server Utilities » SQL loader and record limit (oracle 9.x, windows xp)
SQL loader and record limit [message #385042] Fri, 06 February 2009 05:04 Go to next message
rroooott
Messages: 11
Registered: February 2009
Junior Member
Hello everybody, I need to use sqlldr for parsing a csv file and populate a table. As csv file is potentially very large, I'd like to ask: is there a limit respect to the number of records that the csv can contain?

Thank you!
Re: SQL loader and record limit [message #385044 is a reply to message #385042] Fri, 06 February 2009 05:07 Go to previous messageGo to next message
vivek_rol
Messages: 65
Registered: February 2009
Member
yes
u can't store very large data in csv file , there is limit
use txt file for loading

[Updated on: Fri, 06 February 2009 05:10]

Report message to a moderator

Re: SQL loader and record limit [message #385047 is a reply to message #385044] Fri, 06 February 2009 05:11 Go to previous messageGo to next message
rroooott
Messages: 11
Registered: February 2009
Junior Member
Thank you for your attention.

Could you tell me the amount of this limit?
How many records could I load from a csv file? That is, how many lines could have the csv file'

Thank u
Re: SQL loader and record limit [message #385048 is a reply to message #385047] Fri, 06 February 2009 05:15 Go to previous messageGo to next message
vivek_rol
Messages: 65
Registered: February 2009
Member
use text file
conver csv file into txt file and then load
Re: SQL loader and record limit [message #385049 is a reply to message #385048] Fri, 06 February 2009 05:16 Go to previous messageGo to next message
vivek_rol
Messages: 65
Registered: February 2009
Member
for csv
i think its 65000 rows u can store
Re: SQL loader and record limit [message #385051 is a reply to message #385049] Fri, 06 February 2009 05:24 Go to previous messageGo to next message
rroooott
Messages: 11
Registered: February 2009
Junior Member
Ok, and: is there a limit on the size (kb) of the input size, or to the number of columns that sqlldr is able to handle?

Thank u
Re: SQL loader and record limit [message #385052 is a reply to message #385049] Fri, 06 February 2009 05:26 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
vivek_rol wrote on Fri, 06 February 2009 12:16
for csv
i think its 65000 rows u can store

Can you please tell us the difference between a csv file and a txt file, other that its extension?!

There is no such limit on an inputfile for SQL*Loader.
Re: SQL loader and record limit [message #385070 is a reply to message #385051] Fri, 06 February 2009 05:58 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No limit but OS one for size and number of columns in a table.

Regards
Michel
Re: SQL loader and record limit [message #385075 is a reply to message #385070] Fri, 06 February 2009 06:13 Go to previous message
rroooott
Messages: 11
Registered: February 2009
Junior Member
Ok, so I should't have any problem with the number of lines and columns of the file. If I undestand well, the only linit is due to the OS.
Thank you very much!
Previous Topic: SQL Loader with record Delimiter Issue
Next Topic: wrap utility
Goto Forum:
  


Current Time: Mon Dec 05 08:59:48 CST 2016

Total time taken to generate the page: 0.05276 seconds