Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> truncate partition drop storage doesn't deallocate space
Hi all,
I am trying to truncate a partiton which has 4 extents. After issuing alter table... truncate partition ... drop storage statement I see again 4 extents for this partition in user_extents ...
parition's minextent value = 1
any idea?
thanks in advance. Received on Thu Jun 12 2003 - 04:02:45 CDT