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

Ben wrote:
> 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.

Just an FYI: if destination tablespace/datafile is on autoextend and it extends out, it will not shrink back automatically if the move fails. This could happen if the physical space runs out and you are using autoextend. Received on Thu Nov 09 2006 - 10:33:15 CST