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: Moving tables with constraints

Re: Moving tables with constraints

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 27 Jul 2002 20:32:42 +0100
Message-ID: <1027798289.4862.1.nnrp-13.9e984b29@news.demon.co.uk>

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?)
>
>
>
>
>
Received on Sat Jul 27 2002 - 14:32:42 CDT

Original text of this message

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