Database Oracle

Using files greater then 2GB in Oracle 7

Oracle 7.3.4 can’t read or write to files larger than 2GB ( 2,147,483,648 bytes), so you have to pipe the export/import though gzip.
EXPORT

#!/bin/ksh
. /export/home/oracle7/.profile
# create a named pipe
mknod /oracle/exports/orasid.pipe p
# read the pipe - output to zip file in the background
gzip < /oracle/exports/orasid.pipe > /oracle/exports/export.exp.gz &
exp exp/passwd@orasid file=/oracle/exports/orasid.pipe full=y  direct=y log=/oracle/exports/export.log

IMPORT

#!/bin/ksh
. /export/home/oracle7/.bash_profile
# create a named pipe
mknod /export/home/oracle7/orasid.pipe p
# read the pipe - output to zip file in the background
gunzip > /export/home/oracle7/orasid.pipe < /export/home/oracle7/export.exp.gz &
imp exp/passwd@orasid file=/export/home/oracle7/orasid.pipe fromuser=USER touser=USER