Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: table move changes rowids?

Re: table move changes rowids?

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 18 Nov 2003 10:52:52 -0000
Message-ID: <3fb9fa04$0$262$ed9e5944@reading.news.pipex.net>


"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 Uk
Received on Tue Nov 18 2003 - 04:52:52 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US