Re: Question regarding deleting data.

suggesting the deletes are correctly made, but you don't have any influence on the extents that are made by the various inserts. if you have dictionary tablespace ether or locally managed. Orcale is building it's b*trees allocating and using extents.

I figured out that only large deletions of rows are showing up dropping extents.

if you have some tool like toad it may show you the the used bytes on the disk for a specific table and for dictionary managed tablespaces it seems quite chaotic .........

after deleting a portion of data it`s result is not obviously a continous extent!

--
Posted via http://dbforums.com