|Subject:||alter table X move tablespace Y. what happens if error?|
|Posted by:||Ben (balv…@comcast.net)|
|Date:||9 Nov 2006|
220.127.116.11 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.