Simpler Navigation coming for Servers and Operating Systems
Coming soon: a much simpler Servers and Operating Systems section of the Community. We will combine many of the older boards, and you won't have to click through so many levels to get at the information you need. If you are looking for an older board and do not find it, check the consolidated boards, as the posts are still there.
cancel
Showing results for 
Search instead for 
Did you mean: 

File size getting limited

SOLVED
Go to solution
MAYIANAN
Advisor

File size getting limited

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
4 REPLIES
Pete Randall
Outstanding Contributor
Solution

Re: File size getting limited

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

Pete
Robert-Jan Goossens
Honored Contributor

Re: File size getting limited

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
Honored Contributor

Re: File size getting limited

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Dennis Handly
Acclaimed Contributor

Re: File size getting limited

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