Database - RAC/Scalability (MOSC)

MOSC Banner

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center