I made sure that the system (is large file enabled : ie the filesystem to where I am writing the spool file to is large file enabled)
But oracle software is installed on a mount poit /u01 where large file support is not eanbled. but this should not cause a problem as none of the oracle files a re greater than 2GB.
But I made sure that the fialsystem to which I am spooling to
is larg file enabled.

could there be any other reason.

i can spool a 4GB table to faltfile if I use NT oracle client (with oracle server residing on AIX or Solaris).

Thanks in advance



Geo