Problem in processing a very large file.

Rohini Vijay · #1 (**permalink**) 08-01-2006

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.

jim mcnamara · #2 (**permalink**) 08-01-2006

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.

Code:

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

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Large file FTP problem	rprajendran	UNIX for Advanced & Expert Users	3	06-06-2008 02:46 PM
problem while making ftp of a large file	rprajendran	UNIX for Dummies Questions & Answers	1	05-28-2008 02:19 AM
problem with 0 byte and large files	dsravan	Shell Programming and Scripting	3	04-20-2007 10:59 PM
Problem with parsing a large file	gauravgoel	Shell Programming and Scripting	6	10-18-2006 06:48 PM
Large file transfer problem	VVV	UNIX for Advanced & Expert Users	1	10-22-2005 12:15 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by