Re: Export / Import

From: Ashish Trivedi <abtrived_at_advo.com>
Date: 1997/01/18
Message-ID: <32E1A1BC.2633_at_advo.com>#1/1

Richard Fellner wrote:
>
> Does anyone know any tricks for Exp and Imp ?
>
> 1) To export a 10 gig table to 2 gig DMP segments onto disk ?
> ie. To somehow bypass the 2 gig unix file size limitation !!!
>
> 2) Speed up large exports to tape (ie. Currently approx 1 gig per hour)
>
> Are there any other tools to replace exp or imp ? (ie. faster or better)
>
> Thanks
> Richard
> --
>
> ======================================================================
>
> Richard Fellner Phone: (02) 9239-4008
> Database Administrator Fax: (02) 9239-9242
> Technical Services Group Email: richard.fellner_at_citicorp.com
> CITIBANK Australia Address: 1 Margaret St,
> Sydney, NSW, 2000
> AUSTRALIA
You can compress while doing an export using named pipes in unix.

for e.g

mknod expdat.dmp p
sleep 30
compress <expdat.dmp> &
exp parfile=exp.par

hope this helps..email me if you have any problems..

---

Ashish Trivedi, Database Administrator, Relational Technologies Inc., (860) 285 1552 (O) , abtrived_at_advo.com

+++++++++++++++++ Segmentation fault >^..^< core dumped ++++++++++++++++
________________________________________________________________________

Received on Sat Jan 18 1997 - 00:00:00 CET