How does one overcome the Unix 2 Gig file limit?

Submitted by admin on Sat, 2004-08-07 08:18
Body: 

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 </tmp/data/exp.dmp &
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

»