| ramesh |
Posted: Jan 07, 2008 12:09:11 AM |
Total Post: 77
Joined: Dec, 2006
|
can anyone help me
i hav found this problem many a times, i hav enough of space in the disk then too,
. . exporting table TAXMETHOD 3 rows exported
. . exporting table TAXRATE 55414 rows exported
. . exporting table TAXSET 55420 rows exported
. . exporting table TAXTRAN
EXP-00002: error in writing to export file
EXP-00002: error in writing to export file
EXP-00000: Export terminated unsuccessfully
|
|
|
 ramesh |
| Posted: Jan 07, 2008 12:13:04 AM |  |
|
Total Post: 77
Joined: Dec, 2006
|
i hav found it might be the following reason
"Possible causes are file systems that do not support a certain limit (eg. dump file size > 2Gb) or a disk/filesystem that ran out of space."
how to solve this problem
|
|
|
|
|
| Babu |
| Posted: Jan 07, 2008 01:46:48 AM | |
|
Total Post: 94
Joined: Oct, 2007
|
Are you free space available in your system ?
Babu
|
|
|
|
|
| ramesh |
| Posted: Jan 07, 2008 01:54:02 AM | |
|
Total Post: 77
Joined: Dec, 2006
|
Yes, i'm having enough space,
i had never taken backup on this client machine this is the 1st time.
i had come across such problems many a times, and used to shift backup to other clients.
my server is running on linux and clients are in winxp & win2000
|
|
|
|
|
| Murtuja |
| Posted: Jan 07, 2008 02:38:30 AM | |
|
Total Post: 857
Joined: Jan, 2006
|
Hi,
You can overcome file size limit by this way
C:\>exp user/pass file=(exp1.dmp,exp2.dmp,exp3.dmp) filesize=1024M
filesize=1000M will create 1GB dump files
|
|
|
|
|
| ramesh |
| Posted: Jan 07, 2008 04:01:07 AM | |
|
Total Post: 77
Joined: Dec, 2006
|
Hi.. Murtuja.
i dont want to split the dmp file.
i want the operating system to allow dmp file size > 2GB.
Thanks
|
|
|
|
|
| Murtuja |
| Posted: Jan 07, 2008 04:38:53 AM | |
|
Total Post: 857
Joined: Jan, 2006
|
It's completely depend upon file system i.e fat16,fat32,NTFS
FAT16 has a 2GB file size limit, FAT32 has 4GB as its limit. And the NTFS file system has a 16 exabytes limit.
|
|
|
|
|
| Babu |
| Posted: Jan 07, 2008 06:48:30 AM | |
|
Total Post: 94
Joined: Oct, 2007
|
Good Point Murtuja.
Could you send me links.
|
|
|
|
|
| ramesh |
| Posted: Jan 07, 2008 07:49:19 AM | |
|
Total Post: 77
Joined: Dec, 2006
|
Thanks Murtuja..
for pointing out the reason,
but what i the solution to this, if my filesytem is FAT32 i cannot exceed the limit,
any solutions for this issue,
can u plz send me some links regarding this topic.
Thanks.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
