| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> Re: table move changes rowids?
"Lucyna Witkowska" <ypwitkow_at_nospamcyf-kr.edu.pl> wrote in message
news:bpcrdn$3qb$1_at_srv.cyf-kr.edu.pl...
> 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
Not completing a query seems like quite a performance problem to me :(. On the plus side its unlikely that you'd need more than one support call to realize the indexes needed rebuilding.
-- Niall Litchfield Oracle DBA Audit Commission UkReceived on Tue Nov 18 2003 - 04:52:52 CST
![]() |
![]() |