Release space to asm diskgroup after table drop
Hi Team,
We are on 19.17 database version 2 node RAC.We have dropped a table of size 100GB. We want it to release it to diskgroup. Please guide us to release the space to diskgroup.
SQL> set lines 200 pages 200
SQL> /
TABLESPACE_NAME TOTAL_SIZE_GB FREE_SPACE_GB USED_SPACE_GB PCT_USED
XXTTD_DATA 240 .01 239.99 100----before drop
APPS_TS_MEDIA 435 .37 434.63 99.91
APPS_TS_TX_DATA 467 6.23 460.77 98.67
29 rows selected.
SQL> drop table XXTTD.XXTTD_INV_PMS2ERP_MAIN_STG_BKP purge;
Table dropped.
TABLESPACE_NAME TOTAL_SIZE_GB FREE_SPACE_GB USED_SPACE_GB PCT_USED
APPS_TS_MEDIA 435 .37 434.63 99.91
APPS_TS_TX_DATA 467 6.23 460.77 98.67
XXTTD_DATA 240 98.78 141.22 58.84---after drop