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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s