, bytes/1024/1024 from dba_segments
where segment_name =
the above query gives 1668 MB. is Space occupied by the table.
didn't release the space. Its still showing 1668 MB space
Even in the datafiles its showing as occupied.
- 09-13-2005, 07:05 AM #2Super Moderator
- Join Date
- Dec 2000
- Ljubljana, Slovenia
- 4,439Of course it might not release any space if your initial extents (defined by MINEXTENTS) ar ocupying it all.Code:truncate table my_table drop storage;Last edited by jmodic; 09-13-2005 at 07:07 AM.Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Click Here to Expand Forum to Full Width