Spanning Multiple Files with Imports/Exports 2

[Michael42]

Hello,

I am having an issue with Imports and Exports. My problem is that my Oracle 8.17 export file is 13gig and the largest available disk on my destination system running Oracle 9i (9.2.0.6) only has 6 gig free. Both databases are on Sun Solaris 8 systems.

I tried copying the export file to an NFS mountpoint but as others have confirmed, attempting imports from an NFS mountpoint is not practical because of how long it takes.

1. How can I export a file to two 6gig pieces?
2. How can I perform an import that spans multiple files?

If there is another way to handle this please let me know.

Thanks for spelling this out.

Michael42

 

[stefes007]

Try to export your tables by small groups.

try exp HELP=y

there are some parameter :

FILESIZE maximum size of each dump file

or try
QUERY select clause used to export a subset of a table

Dekeyzer Stephane.
Belgium

 

[sem]

Try to compress it, move to destination and then import via pipe.

Regards, Dima

http://seminihin.narod.ru

 

[LKBrwnDBA]

sem is right, but you may still need to split the file:

# Example KSH code:
EXPP=/tmp/exp.pipe
mknod $EXPP p
cat $EXPP|gzip -c|split -b 2000m - expfile.dmp.gz &
exp / file=$EXPP log=/tmp/exp.log full=y ...etc...
rm -f $EXPP

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[Michael42]

Thanks all your suggestions worked great!