Exporting file not exceeding more then 2.1 GB

[shan_7]

Hi everybody,

Hp e -45 server having HP-ux 10.20. i facing the problem that is whenever i try to export the oracle data backup to *.dmp file,i am getting the following message. after the file reached the capacity of 2.1 GB.

error in writing file export file
system error no such directory or file
export terminated.

i am suspecting the file size, coz whenever the exporting file reaching the size of 2.1 GB then the exporting terminated.

Help me in this case anyone.

thanks in advance,

Shankar Ganesh

[Mark Grant]

Your 2.1Gb is probably exactly 2GB and you don't have large file enabled on the filesystem.

The filesystem must be created with the "-o lagefiles" option though you can do this online if you have online jfs. You also have to mount the filesystem with "-o largefiles" option.

mount -F vxfs -o largfiles /dev/vgxx/lvolx /mydirectory

[Sanjay Kumar Suri]

Check the support with

fstyp -v file_system

the output should show the value of f_flag: 16 in case largefile is supported.

sks

[Steve Steel]

Hi

From
http://www.orafaq.com/faqunix.htm

How does one overcome the Unix 2 Gig file limit?
This example uses the Unix split command to create multiple files, each smaller than the Unix (and imp/exp) 2 Gigabyte file size limit. This method can typically be used for import, export and SQL*Loader operations.
cd /tmp/data
rm exp.dmp
mknod exp.dmp p # mkfifo on certain Unix flavours
split -b2047m exp scott/tiger file=/tmp/data/exp.dmp record=n tables=tableX

cd /tmp/data
rm exp.dmp
mknod exp.dmp p
cat xaa xab xac xad >/tmp/data/exp.dmp &
imp scott/tiger file=/tmp/data/exp.dmp commit=y tables=tableX



See
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=76776



Steve Steel

[Karthik S S]

fsadm -o largefiles /mount_point
or
fsadm -o largefiles /device_file_name

-Karthik S S

[Ted Buis]

When you say export, do you mean you are using NFS? NFS file size limits are different from those of the native file system, and depends on the version of NFS you are running. You may have to check on those limits too if you are using NFS.