Unix & Oracle Script - Creating File 2gig +

[saw15]

Working with Unix and Oracle.

I am calling sqlplus to spool a text file on the Unix box. I need two years worth of data, rather easy script.

Problem, is that when I run the script, it generates approx 2.097 gig worth of data in the *.txt file and then simply stops.

Is this a limitation for a single text file? The filesystem is not running out of space.

Is there a way around this?

Thanks.

 

[bi]

in version 11.0, if the filesystem isn't large file enabled, you won't be able to have files larger than 2 GB. You can change the filesystem to be large file enabled (I tested it through sam, but you can do it with the fsadm command on the command line. See the man page for fsadm.) The filesystem is unmounted when the change is made through sam. I don't know if it would have to be with fsadm if you have advanced online jfs.

I use version 11.0. I'm not sure if this is available in earlier versions of HP-UX.

 

[Guest_imported]

Try using the following : (use split and fifo-mknod)
cd /tmp/Oracle
rm spool.txt
mknod spool.txt p
split -b2047m </tmp/Oracle/spool.txt &
sqlplus scott/tiger@ORCL @SCR.sql #put the spool file path as /tmp/Oracle/spool.txt

cd /tmp/Oracle
rm spool.txt
mknod spool.txt p
cat xaa xab xac xad > /tmp/Oracle/spool.txt $ vi /tmp/Oracle/spool.txt

Hope this solves your problem.

 

[saw15]

Exactly what I needed on both accounts. Thankyou very much.

 

[williamlopez]

Hello saweens,

You need to have enabled that the filesystem support files greater than 2GB, to support this try
1. ummount the filesystem
2. fsadm -F hfs -o largefiles /dev/vgxx/lvolxx, replace xx with the information about the filesystem where you want big files.