Re: recommended way of exporting/importing big data sets
From: <gareth_at_jamms.org>
Date: Wed, 11 Mar 2009 06:59:54 -0700 (PDT)
Message-ID: <42919c5c-0978-410e-a3ee-1c3d5969d96a_at_l38g2000vba.googlegroups.com>
On 11 Mar, 12:49, krzysztof cierpisz <ciape..._at_gmail.com> wrote:
> > exp/imp is perfectly capable of doing what you want.
>
> since many GBs will be transferred is it wise to set
> COMPRESS=Y ?
>
> or it will slow done the whole process a lot?
>
> chris
Date: Wed, 11 Mar 2009 06:59:54 -0700 (PDT)
Message-ID: <42919c5c-0978-410e-a3ee-1c3d5969d96a_at_l38g2000vba.googlegroups.com>
On 11 Mar, 12:49, krzysztof cierpisz <ciape..._at_gmail.com> wrote:
> > exp/imp is perfectly capable of doing what you want.
>
> since many GBs will be transferred is it wise to set
> COMPRESS=Y ?
>
> or it will slow done the whole process a lot?
>
> chris
COMPRESS=Y merely causes imp to consolidate all extents in the original table into one extent upon import. It does not actually compress data.
http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/exp_imp.htm#sthref2244
HTH -g Received on Wed Mar 11 2009 - 08:59:54 CDT