I have a table called EMP which is in the EMP_TBS tablespace. The table EMP is fragmented so I want to use the alter table move command to fix the fragmentation issue. I do not want to move the table into another tablespace, I want it to remain in the same tablespace. ButI am not sure if I isuue "alter table EMP move" will work if the table that I am moving is going to remain in the same old tablespace.
Any thouhghts on that?