alter table X move tablespace Y. what happens if error?

Giganews Newsgroups
Subject: alter table X move tablespace Y. what happens if error?
Posted by:  Ben (balv…@comcast.net)
Date: 9 Nov 2006

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.

Replies