This is most certainly because you have reached your max OS filesize limit.
What is your OS ?
I unix you can set ulimit -f unlimited to have an unlimited file size for that sessions.
Hard and Soft file size kernal parameters can be set to unlimited for the whole system if you wish, talk to your Unix SA.
ulimit -a usually shows you current settings.
There are also other ways of generating an export fle less than 2GB's, one way is to split the exports up. Search forums on how to do this, there have been many threads on this subject.
Once you have eliminated all of the impossible,
whatever remains however improbable,
must be true.
Jeff has provided you with a good solution, there are some good scripts in the tips section.
If you rellay want to look into unlimiting your file max block size then :
a.Log in as the user runing the export(oracle) NOT root.
b. ulimit on it's own is not good enough. you need to specify a parameter as there are many resource limits that ulimit will supply information on. 'man ulimit' will tell you what each parameter means, use the right one!
ulimit -f usually tells you max number of blocks on files.
ulimit -a usually lists limits for all resources.
You need to know max number of blocks on files.
You can either set ulimit -f unlimited for current session or change kernal parameters
In SCO Unixware SFSZLIM and HFSZLIM are set to 0x7FFFFFFF for unlimited.
Now I am trying with the pipe option with compressing. Well, I have Solaris 8 with Vxsfs file system. We enabled largefiles in the /etc/vfstab. So system should not stop at 2GB. Pleae somebody tell me why the export is terminated at 2GB... If I am correct, a file can grow upto 2TB in vxfs largefiles.. So how I am getting the error..???
Currently I took the export backup and the .Z size is 153MB... Wow..life is very easy.. if the things are known..!
Thanks to all..
Technical Lead (Databases)
Thomson Reuters (Markets)