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
.
- Read more about Using files greater then 2GB in Oracle 7
- Log in or register to post comments