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
time(seconds)        unlimited
file(blocks)         unlimited
data(kbytes)         unlimited
stack(kbytes)        unlimited
memory(kbytes)       unlimited
coredump(blocks)     unlimited
nofiles(descriptors) 2000
 
Thanks
 
Satish 

Reply via email to