If I have a HWM on the table, I move the tabes to different tablespaces using :
ALTER TABLE TABLE_NAME MOVE NEW_TABLESPACE;
what if I move the table on the same tablespace like:
ALTER TABLE TABLE_NAME MOVE;
the question is "is it bad thing to move the table on the same tablespace??? which may cause fragmentation on the tablespace b/c of the old segment???"
I am on 9i and using local extent
have a great weekend to all.