Oracle Database Discussions

Hi There!

I got a table with 5.7Tb and it´s fragmented, so I need to reclaim space in that datafiles.

How the table is stored in a LMT Tablespace, I´m unable to do a shrink space and hence, I´m thinking in to do a rebuild in this table, issuing the move command to the same tablespace.

I don´t have more space to create a new tablespace with the same size as the concerned tablespace to do a reorganization.

I dropped old partitions, in order to release some space in tablespace and now I got 2.3Tb free.

This is a partitioned table and my concern is how I don´t have enough space to create another tablespace, if I run the move to the same tablespace, I´ll use the relesed space in the tablespace or do I have to increase space in my temp tablespace?

Other doubt is if I run this online, will I lock the table exclusively?

Thanks in advance!

Regards