Resize table ont.OE_ORDER_LINES_ALL
I have check the allocation Size vs Actual Size, I think the shrink
space should release 4G space but after I alter the table the sql result
is same.Did I miss something? Thanks in advance
select table_name,round((blocks*8),2)/1024/1024||'G' "Allocate Size"
,round((num_rows*avg_row_len/1024),2)/1024/1024||'G' "Actual Size"
from all_tables
where 1=1
and table_name in ('OE_ORDER_LINES_ALL','AR_RECEIVABLE_APPLICATIONS_ALL','AP_INVOICES_ALL','OE_ORDER_HEADERS_ALL')
--and tablespace_name = 'APPS_TS_TX_DATA'
and round((blocks*8),2)/1024/1024 >1;
TABLE_NAME Allocate Size Actual Size
OE_ORDER_LINES_ALL 7.756 G 2.733G
alter table ont.oe_order_lines_all enable row movement;
select table_name,round((blocks*8),2)/1024/1024||'G' "Allocate Size"
,round((num_rows*avg_row_len/1024),2)/1024/1024||'G' "Actual Size"
from all_tables
where 1=1
and table_name in ('OE_ORDER_LINES_ALL','AR_RECEIVABLE_APPLICATIONS_ALL','AP_INVOICES_ALL','OE_ORDER_HEADERS_ALL')
--and tablespace_name = 'APPS_TS_TX_DATA'
and round((blocks*8),2)/1024/1024 >1;
TABLE_NAME Allocate Size Actual Size
OE_ORDER_LINES_ALL 7.756 G 2.733G
alter table ont.oe_order_lines_all enable row movement;
0