2 Gb file limit problem

From: Satish Iyer <Satish.Iyer_at_ci.seattle.wa.us>
Date: Mon, 30 Jul 2001 10:55:35 -0700
Message-ID: <F001.00359078.20010730102043@fatcity.com>

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 - 12:55:35 CDT