-
Hi All
I got a Database of 75GB. When taking export (FULL=Y) the dump file is created upto 2GB (Exactly 2147483647 May 23 00:04 EXPsib220502.dmp ) and terminating giving the error as follows.
. . exporting table TD_DEFN_TABLE
EXP-00015: error on row 141887 of table TD_DEFN_TABLE, column ACID, datatype 1
EXP-00002: error in writing to export file
EXP-00002: error in writing to export file
EXP-00000: Export terminated unsuccessfully
It was exporting with out any problems to this size. I am sure the problem is associated with the size of the dump file..! But how to solve..? What could be the solution.. !??
Please help!
Thanking in advance
Thomas
-
-
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.
-
Hi
Thanks..
marist .. I will check it out..
Sureshy:
1. My ulimit is unlimited
# ulimit
unlimited
2. I am using veritas file system (vxfs). All my file systems mounted with largefiles option..
/exp on /dev/vx/dsk/dbdg/vol05 read/write/setuid/log/largefiles/ioerror=mwdisable/dev=3799a2c on Wed May 22 00:52:40 2002
So do you think that it could be a problem..
Regards
Thomas
-
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.
For further help on your flavour of unix visit :
http://www.unix.com
Suresh
-
I have had this problem on our HP/UX boxes here. We have to contact the Unix Sys Admin and have him enable large files on the specified mount points. I guess it is a Unix default, not sure though.
MH
-
Exoprt
Hi
Thanks all..
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..
