Database Utilities (MOSC)

MOSC Banner

Resize table ont.OE_ORDER_LINES_ALL

edited Feb 19, 2012 3:54AM in Database Utilities (MOSC) 4 commentsAnswered
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;

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