Space required for MOVE op !
We have a part. table prod. 48 Gb ( 7 partitions) in size extent alloc system with the least extent size: 65536 and the greatest: 67108864
Indexes: 3 locally part.
It had 65 M rows and we delete approx 2M rows and 450K rows are
inserted daily. The deletes were put in place to control growth and filling up of the filesystem.
How much space is required to do an ALTER TABLE MOVE PARTITION ? As in our UAT env it fails midway with an
ORA-01652: unable to extend temp segment by 4096 in tablespace
error.
TIA
:)