9.2.0.5 EE AIX5L
I've searched on AskTom, looked at the Admin & Concepts manuals, and
searched here but I can't find anywhere that tells me what happens to
my table if an 'ALTER TABLE X MOVE' fails.
I thought I remembered reading somewhere that the table move creates
temp segments in the new tablespace that are converted to permanent
segments after completion. So I can see that the new segment would
cease to exist if it failed during execution. But what happens to the
original? Nothing I'm assuming, but I just wanted to revist this before
I actually perform.
Received on Thu Nov 09 2006 - 09:08:31 CST
