move table

[panjub_raj]

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?

[marist89]

Yup, it will work.

[pando]

yea it works as long as you have enough big free chunk extent, alter table move locks the table though

[panjub_raj]

So assuming the table EMP is using its 45 extents, will the alter table move command make all the extents one?

[marist89]

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.

[panjub_raj]

thanks