Re: Moving tables with constraints

Paul,

No need to apologise. I should have
put one of those silly face things after the complaint.

The most important point was in my second paragraph - I was guilty of a stating as fact something which I had not qualified sufficiently.

And, of course, I had mis-interpreted your issue anyway. It is hard to imagine that moving the tables HOLDING the snapshots should have any impact on the existence of rowids.

Regards

--
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
<3d43008a_2_at_mk-nntp-1.news.uk.worldonline.com>...


>

>The problem was that when I moved the local table which 'holds' the

>snapshot, the contents of the M_ROW$$ column seemed to be truncated.

>This database is pre-production, and the snapshots are small, so the

problem


>was easily worked around by dropping and recreating the snapshots - it was

>only half an hour or so - quicker than restoring and recovering.

>