File size getting limited

[MAYIANAN]

Hi all,

When i try to extract records from oracle the file size in unix is getting limited to 2GB. The actual size should be 9GB.Is this an oracle error or unix error?

i just extract like

connect
spool
select query
spool off

-Mayilvahanan

[Pete Randall · Accepted solution]

The most likely cause would be that the filesystem is set to "nolargefiles", thus limiting the size of files which can be created in it. Run "fsadm" to check:

# fsadm /opt
fsadm: /etc/default/fs is used for determining the file system type
largefiles
# fsadm /
fsadm: /etc/default/fs is used for determining the file system type
nolargefiles


Pete

[Robert-Jan Goossens]

Hi,

Could be the filesystem has not been set to enable largefiles >2GB

with OnlineFFS
# fsadm -F vxfs /filesystem
# fsadm -F vxfs -o largefiles /filesystem

without OnlineJFS
# fsadm -F vxfs /dev/vgXX/lvolX
# umount /filesystem
# fsadm -F vxfs -o largefiles /dev/vgXX/lvolX

Regards,
Robert-Jan

[Yogeeraj_1]

hi,

You should enable largefiles support on the file system as mentioned. If this cannot be done immediately, you may wish to create a new file system using SAM and enable the largerfiles support there itself. Then once mounted, you can proceed with the spool operation.

Also, to get a better performance, it is preferrable not to echo the output to the current session screen.

good luck!

kind regards
yogeeraj

[Dennis Handly]

I don't think you need OnlineJFS to do this, at least on 11.23.