concerns over ALTER MOVE of very large tables.

Oracle 11.2.0.2  Std. Ed One

ASM 11.2.0.3

Oracle Linux 5.6 64bit

This is a follow on to my previous thread "deleting data file that has been offline for extended time".  Also posted on OTN

 

Long
story short, due to a perfect storm of errors by my back-fills while I
was out on medical leave, I am having to move all segments from one TS
to a newly created TS and drop the old when it is empty. 

 

I
have a script found on AskTom to generate all the necessary ALTER TABLE
MOVE and ALTER INDEX REBUILD statements.  For sanity, instead of
running them all en mass,  I’m taking each table in turn (and good thing