Re: Exporting large (>8 gig) database in UNIX?

Gary Melhaff wrote:
>
> You do the unix pipe using mknod utility.
>
> Example...
> mknod /tmp/exp_pipe p
> compress < /tmp/exp_pipe > prod_exp.dmp.Z
> exp userid/password file=/tmp/exp_pipe ....other parms here or in
> parfile

<Stuff deleted>

> Bottom line, if you have export that compressed is larger than 2 gig
> and exp larger than tape size, you're screwed.
>

Hi all,

No, you *ARE* *NOT* *SCREWED* !

There is another solution which works well if you have sufficient disk space : the split command :

mknod /tmp/exp_pipe p
exp full=y file=/tmp/exp_pipe userid=system/password ... other params split -b 1024m /tmp/exp_pipe /exp_dir/file_name.

This works on systems where split recognizes the -b option ( splitting factor in bytes instead of lines ).

This sequence will create 1Gigbytes files named file_name.aa, file_name.ab, ... and so on in the directory /exp_dir

HTH,
Jerome. Received on Wed Nov 05 1997 - 00:00:00 CST