Home » RDBMS Server » Server Utilities » max filesize for sql loader
max filesize for sql loader [message #368338] Sun, 19 November 2000 11:07 Go to next message
florian boldt
Messages: 1
Registered: November 2000
Junior Member
are there any limits for the size of an file to load with sql loader ? someone told me 2 GB, but i can't find anything concerning the file size in the docs.

thank you
Re: max filesize for sql loader [message #368341 is a reply to message #368338] Tue, 21 November 2000 10:19 Go to previous messageGo to next message
Messages: 236
Registered: July 2000
Senior Member
2GB is an OS limit in most of the UNIX system. I know that there is an exception on AIX if large volume groups are used, in which case it can you beyond 2GB limit, I think upto 8GB (I said I think).
Re: max filesize for sql loader [message #368385 is a reply to message #368341] Mon, 11 December 2000 19:30 Go to previous message
Messages: 122
Registered: September 2000
Senior Member
Hi The 2gb limit for the file is actually the ASCCI file limit,which exists on all the unix systems too.regardless of Oracle version
set the ulimit in the unix file system to unlimited for enableing the large file system(option availblae in IAIX4.3.x)
and solaris 6.x onwards]]
but since this is the ASCII file limit we can't do anything in tha
But there are alternate mathods are avilable such as
using the pipe commands and cat commands
If u want i can send u the exact syntax
Previous Topic: Export/Import across a network
Next Topic: dBase to Oracle8
Goto Forum:

Current Time: Sun Dec 05 08:14:10 CST 2021