I have done extraction of large table data (4GB table) using Oracle client (Client on NT) and with Oracle server on NT, AIX and Solaris platforms without any problem. The scripts are run on SQLPLUS and is a plain select statement extracting into a pipe-delimited txt file. The extraction went fine as long as Oracle client is on NT.

But if I use Oracle cleint on UNIX (AIX and Solaris), the extraction cuts of at 2GB without any error message.

Is there a way to get around this problem.


Thanks in advance,

Geo