Re: Moving tables with constraints

There's always one trouble maker !

I sympathise - too many people make
sweeping generalisations and give hints
which apply only under special conditions.

On the other hand - the existence of a
rowid-based snapshot might make me
pause for thought before I performed an
action on a base table that was supposed to change all the rowids :(

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Next Seminars
 UK  Sept
 Australia August
 Malaysia September
 USA x 2  November

http://www.jlcomp.demon.co.uk/seminar.html

Paul Brewer wrote in message
<3d3f6a69$1_2_at_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?)

>

>

>

>

>