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?
No. Without specifying storage parameters, ALTER TABLE ... MOVE will use the existing parameters and you will probably end up with the exact same number of extents you had before. Change the command to ALTER TABLE... MOVE STORAGE (initial xM next xM ...) to resize it.