move partition to reduce space
oracle 10.2.0.4
I tried to move a partition form 64mg extent size tablespace to 128k extent size tablespace but it did not work. There is no rows in this partition.
In the original tablespace it took 64 MG 1 extent. after i moved the partition to the 128k tablspace, it is taking 512 extents, the initial extent of 64mg and next extent 128k. how could i fix this so Oracle will use only one 128k extent since there are no data on this partitions.
ALTER TABLE IMPORT_TEST_QA.GMI_ADDRESS MOVE PARTITION SYS_P1659055 TABLESPACE EMI_PATIENT_SMALLD_10K
I tried to move a partition form 64mg extent size tablespace to 128k extent size tablespace but it did not work. There is no rows in this partition.
In the original tablespace it took 64 MG 1 extent. after i moved the partition to the 128k tablspace, it is taking 512 extents, the initial extent of 64mg and next extent 128k. how could i fix this so Oracle will use only one 128k extent since there are no data on this partitions.
ALTER TABLE IMPORT_TEST_QA.GMI_ADDRESS MOVE PARTITION SYS_P1659055 TABLESPACE EMI_PATIENT_SMALLD_10K
0