Re: Reorg Oracle 8 Partition tables

From: Peter Sharman <psharman_at_us.oracle.com>
Date: Wed, 10 Feb 1999 15:33:46 -0800
Message-ID: <36C21759.5ED23E31@us.oracle.com>

Kevin

Before re-orging I would have to ask why are you doing this. Having an object in multiple extents is NOT a problem, regardless of the predominant thinking that it is.

HTH. Pete

Lo wrote:

> Help,
>
> My partitions are increasing in extents, and I will need to re-organise
> them. I need to know which is the easiest way to do it.
>
> Do I:
> 1. Use the "move" partition command.
> 2. Export/Import the table into a adequately sized partitioned table, or
> does export/import compress extents.
>
> Thanks in advance,
> Kevin

Regards

Pete

Peter Sharman                              Email: psharman_at_us.oracle.com
WISE Course Development Manager            Phone: +1.650.607.0109 (int'l)
Worldwide Internal Services Education               (650)607 0109 (local)

San Francisco

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA

Received on Wed Feb 10 1999 - 17:33:46 CST