what's the step to reorganize a table by using CTAS?

[sambavan]

That would be inconsistent creation. Instead you could lock and do this, that way you can ensure the consistency. Other wise, once after you do this move, then do the consistency check.

Sam