Re: Reorg Oracle 8 Partition tables

Is 10,000 more than a few ?

Steve Phelan wrote:

> 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 - 15:26:39 CST