Re: Question on re-organising Tables

From: Howard J. Rogers <howardjr_at_dizwell.com>
Date: Fri, 08 Oct 2004 05:47:48 +0000
Message-ID: <41659e0e$0$10349$afc38c87@news.optusnet.com.au>

Holger Baer wrote:

> 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.

Bzzzt!!!

Hoist with my own petard, as they say.

:-(
HJR (Enjoy the 10g course. It's pretty good, if it's the Oracle one.) Received on Fri Oct 08 2004 - 00:47:48 CDT