Re: table move changes rowids?

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Tue, 18 Nov 2003 08:03:28 -0800
Message-ID: <1069171431.922983@yasure>

Lucyna Witkowska wrote:

> Michael J. Moore <NOhicamelSPAM_at_comcast.net> wrote:
>

>>Thanks for the info. I'd hate to imagine the performance problems that could
>>result if you didn't know you had to rebuild the indexes.

>
>
> Not performance problems but ORA-01502 error!
> I wonder why 'alter table move' don't rebuild indexes itself.
>
> Greetings,
> LW

Because it doesn't know where you might want them rebuilt or with what modifications.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Tue Nov 18 2003 - 10:03:28 CST