OraFAQ Forum: Server Utilities » SQL loader and record limit

Home » RDBMS Server » Server Utilities » SQL loader and record limit (oracle 9.x, windows xp)

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

SQL loader and record limit [message #385042]

Fri, 06 February 2009 05:04

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!

Report message to a moderator

Re: SQL loader and record limit [message #385044 is a reply to message #385042]

Fri, 06 February 2009 05:07

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

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

Report message to a moderator

Re: SQL loader and record limit [message #385048 is a reply to message #385047]

Fri, 06 February 2009 05:15

vivek_rol
Messages: 65
Registered: February 2009

Member

use text file
conver csv file into txt file and then load

Report message to a moderator

Re: SQL loader and record limit [message #385049 is a reply to message #385048]

Fri, 06 February 2009 05:16

vivek_rol
Messages: 65
Registered: February 2009

Member

for csv
i think its 65000 rows u can store

Report message to a moderator

Re: SQL loader and record limit [message #385051 is a reply to message #385049]

Fri, 06 February 2009 05:24

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

Report message to a moderator

Re: SQL loader and record limit [message #385052 is a reply to message #385049]

Fri, 06 February 2009 05:26

Frank
Messages: 7901
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.

Report message to a moderator

Re: SQL loader and record limit [message #385070 is a reply to message #385051]

Fri, 06 February 2009 05:58

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

Report message to a moderator

Re: SQL loader and record limit [message #385075 is a reply to message #385070]

Fri, 06 February 2009 06:13

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!

Report message to a moderator

Previous Topic:	SQL Loader with record Delimiter Issue
Next Topic:	wrap utility

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 29 11:19:03 CDT 2024