Hello Oracle Comunnity,
I'm about to make an online reorg of the majority of the content of a tablespace or maybe the whole tablespace.
I'm very worried about one thing. At the end of this operation, I need to reclaim space from the corresponding datafiles, determinating the unused space above the last used block inside each file.
But first, I have to recreate the objects inside the tablespace using RDBMS_REDEFINITION package. My question is :
During an online reorg, does Oracle relocate extents of redefined objects at the beginning of the "container" datafile ?
Here are :
- my Oracle version : 11.2.0.3.0 patch 39
- OS version : Windows Server 2008 R2
NB : For some reasons like optimisation, I have to use this package, instead of SCHRINK SPACE command, but I could change my point of view if really necessary.