Re: Reorg Oracle 8 Partition tables

So 10,000 extents, all just a bit under the multi-block I/O count * block size, on a partition that is predominantly full scanned is not a problem, then?

Or is that just 'predominant thinking'?

Steve Phelan.

(Oracle 7 & 8 OCP)

Peter Sharman wrote:

> 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 Fri Feb 19 1999 - 14:58:15 CST