Re: Moving tables with constraints

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Thu, 25 Jul 2002 01:11:33 +0100
Message-ID: <3d3f6a69$1_2@mk-nntp-1.news.uk.worldonline.com>

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:1027533132.29954.0.nnrp-01.9e984b29_at_news.demon.co.uk...
>
> It makes a big difference -
>
> Look at:
> alter table XXX move;
> followed by
> alter index YYY rebuild;
>
>

Hah!

I just did that (8.1.7.0.0) with a set of snapshots, moving them out to my shiny new small, medium and large-objects LMTs as recommended, and it corrupted all the local copies of the remote rowids. And no, I couldn't use primary key instead of rowid for the fast replication, because this was Peopleshit. Had to drop and recreate the snapshots to recover.

Paul
(Bitter? Moi?) Received on Wed Jul 24 2002 - 19:11:33 CDT