Re: Partition exchange between different tablespaces

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Sun, 14 Jul 2002 20:36:05 +1000
Message-ID: <EncY8.34738$Hj3.104814@newsfeeds.bigpond.com>

Hi Andre,

Not sure you've got it right.

A partition exchange *does not* move data around. It only makes changes to the data dictionary and renames the table to be the partition and renames the partition to be the table (and optionally associated indexes as well). The data remains in the original tablespaces.

Makes sense ?

Regards

Richard
"AndreSiregar 2002" <dregar_at_yahoo.com> wrote in message news:303ac334.0207131938.361000cd_at_posting.google.com...
> Is it advisable to perform partition exchange between tables in
> different tablespaces? I did a little experiment and it seems like the
> physical location of the data is not moved from tablespace A to B
> immediately (as seen in dba_segments). However, inserting new records
> in tablespace A, I can force these segments to be replaced by new data
> (and I guess moved to tablespace B). Am I interpreting Oracle
> correctly?
>
> Sorry I don't have scripts that I can show as I'm writing this from
> home and the database is at work.
>
> Andre
Received on Sun Jul 14 2002 - 05:36:05 CDT