Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Exporting large (>8 gig) database in UNIX?

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

From: Jerome Grandjanny <grandjanny_at_ldg.bruyeres.cea.fr>
Date: 1997/11/05
Message-ID: <34602592.63BD@ldg.bruyeres.cea.fr>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US