Problem in processing a very large file.

Shell Programming and Scripting
1

Hi Friends,

Getting an error while processing a very large file using an sqlloader........

The file is larger than 2 GB. Now need to change the compiler to 64-bit so that the file can be processed.

Is there any command for the same.

Thanks in advance.

2

Unless you expect to use thousands of large files (>2GB) just use split to whack the file into two/three pieces. sqlldr -> the first file, then the second. split should be able to read files that large... if your filesystem correctly handles the big file.

split -b 270000000 file.dat  split_file
for file in `ls split_file*`
do
   sqlldr data="$file" control=somefile.ctl
done