Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Using split and pipe to avoid 2 GB file size limit on HP-UX for exports
Export to several files
% mknod /tmp/exp_pipe p # Make the pipe % cd /fs_with_25gig_freespace # Make sure disk has space % split -b2047m < /tmp/exp_pipe & # Split input to 2Gb chunks % exp user/passwd file=/tmp/exp_pipe full=y # Export to the pipe
This will split the export into several files called 'xaa', 'xab', 'xac' all of size 2047Mb. These can be fed back into import thus:
% mknod /tmp/imp_pipe p # Make the pipe % cd /fs_with_25gig_freespace % cat xaa xab xac > /tmp/imp_pipe & # Put files into the pipe % imp user/passwd file=/tmp/imp_pipe # And import
HTH NeilC
Fender wrote in message <820pde$kjj$1_at_nntp3.atl.mindspring.net>...
>I saw a procedure to do this posted here a couple months ago. It involved
>creating a FIFO pipe and split file. I have an export that has now grown
>past 2 GB. I can change the file systems to allow files greater than 2 GB,
>but some utilities (gzip, tar) do not work with files that large. If
>someone could repost the procedure, I'd appreciate it.
>
>Thanks,
>
>Eric
>
>
>
Received on Tue Nov 30 1999 - 09:50:31 CST