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.