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 -> Tip: Exporting the files bigger than 2G

Tip: Exporting the files bigger than 2G

From: Tanya Injac <Tanya.Injac_at_nz.eds.com>
Date: Mon, 11 Jan 1999 15:14:07 +1200
Message-ID: <36995E6F.2B04@nz.eds.com>


Hi.

I've got one more tip for splitting the big exports directly from the command line:



echo|exp file=>(split -b 1024m - exp-) userid=system/manager tables=A

Of course, you can put any "exp" parameters. This is working only in ksh and has been tested on Sun Solaris 5.5.1.

Import command:



echo|imp file=<(cat exp-??) userid=system/manager tables=A

Splitting and compressing at the same time:



echo|exp file=>(compress|split -b 1024m - exp-) userid=system/manager tables=A
echo|imp file=<(cat exp-*|zcat) userid=system/manager tables=A

Best regards,
Tanya

Tanya Injac
Database Administrator
EDS NZ Ltd
Phone: 474 5228
Mobile: 021 2173940
Fax: 495 9473 Received on Sun Jan 10 1999 - 21:14:07 CST

Original text of this message

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