Re: Partition exchange between different tablespaces

From: D.Y. <dyou98_at_aol.com>
Date: 14 Jul 2002 04:36:19 -0700
Message-ID: <f369a0eb.0207140336.4f7f8404@posting.google.com>

dregar_at_yahoo.com (AndreSiregar 2002) 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?
>

Partition exchange merely exchanges the names of the segments involved. System catalog is updated to reflect this. Locations of data segments will not be exchanged, but index segments need to be rebuilt since the old rowids are no longer valid.

> 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 - 06:36:19 CDT