Re: 2 Gb file limit problem

From: JOE TESTA <JTESTA_at_longaberger.com>
Date: Mon, 30 Jul 2001 12:34:13 -0700
Message-ID: <F001.0035930F.20010730115141@fatcity.com>

how about this:
 

(avg_row_size + delimiters) * number_of_rows = total bytes.
 

total bytes / 1900000000 = number of pieces.
 

number_of_rows / number_of_pieces = number of rows per piece
 

select number of rows needed multiple times, spooling each one individually.
 

then sqlldr all the pieces.
 

joe
 

>>> Satish.Iyer_at_ci.seattle.wa.us 07/30/01 02:20PM >>>
Hi List,
 

I need to transport few tables from one instance to another and of course found the sqlldr method much faster than the exp/imp.

But the problems is for large tables .When I spool such input tables to a flat file , it stops spooling into it after about
 2 Gb. Any possible solutions to get around it. I am on AIX
4.3.3/8.1.5
 

My ulimits on AIX  are
<FONT face=Arial

size=2>time(seconds)        
unlimitedfile(blocks)         
unlimiteddata(kbytes)         
unlimitedstack(kbytes)        

unlimitedmemory(kbytes)      
unlimitedcoredump(blocks)    
unlimitednofiles(descriptors) 2000
 

Thanks
 

Satish  Received on Mon Jul 30 2001 - 14:34:13 CDT