Re: Question on re-organising Tables

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Thu, 07 Oct 2004 18:05:44 +0200
Message-ID: <ck3pgp$prq$1@news.BelWue.DE>

Howard J. Rogers wrote:
> Holger Baer wrote:
>

>>>
>>
>>Not withstanding HJR's advice, why don't you just 'alter table move ...' ?

>
>
>
> Good suggestion, btw. And it's a bit quibbling of me to mention that there's
> only one one possible downer with it: moving a table requires potentially
> twice the amount of Oracle-allocated disk space as the single table uses.
> Whereas it would be possible to export to some disk that is not otherwise
> used by Oracle.
>
> Oh, and OK... a second downer: moving a table causes a hell of a lot of
> buffer cache activity. Export doesn't, in direct path mode anyway.
>
> Oh, and a third possible: moving a table requires that you *remember* to
> rebuild all your indexes. Importing one does it for you, by default.
>
> Dull it may be, but export still has its uses!!
>
> :-)
> HJR
>
>

Point taken. I was just sloppy because 5 minutes after writing I had to rush off or I'd be late to the '10g New Features' course I was attending today. I actually thought about mentioning the need to rebuild the indexes but then I was already late. Never write in a hurry, I learned that much.

But just to show that I carefully read every bit you write ;-) :

Of course you don't have to rebuild *all* your indexes. Only those that happened to be on the moved table.

Cheers,

Holger Received on Thu Oct 07 2004 - 11:05:44 CDT