Re: Question re: TRUNCATE ... REUSE STORAGE

From: Tanel Põder <tanel.poder.003_at_mail.ee>
Date: Fri, 2 Jul 2004 19:04:52 +0300
Message-ID: <02c901c4604e$4fc4f540$e8879fd9@porgand>

> No, the high water mark is reset to the top of the allocated space. The
> option means the allocated space remains allocated to the object. "Drop
Mark, the HWM is reset to point to first block after segment header when you truncate with keep storage (sometimes referred as HWM is reset to zero). Just the extent map is kept.

A table header block with some rows:

  Extent Header:: spare1: 0      spare2: 0      #extents: 11     #blocks: 87    
                  last map  0x00000000  #maps: 0      offset: 4128  
      Highwater::  0x00406d72  ext#: 10     blk#: 1      ext size: 8     
  #blocks in seg. hdr's freelists: 0

#blocks below: 80

Truncated with reuse storage:

  Extent Header:: spare1: 0      spare2: 0      #extents: 11     #blocks: 87    
                  last map  0x00000000  #maps: 0      offset: 4128  
      Highwater::  0x00406d22  ext#: 0      blk#: 0      ext size: 7     
  #blocks in seg. hdr's freelists: 0     
  #blocks below: 0

Truncated with drop storage:

  Extent Header:: spare1: 0      spare2: 0      #extents: 1      #blocks: 7     
                  last map  0x00000000  #maps: 0      offset: 4128  
      Highwater::  0x00406d22  ext#: 0      blk#: 0      ext size: 7     
  #blocks in seg. hdr's freelists: 0     
  #blocks below: 0

Tanel.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Fri Jul 02 2004 - 11:01:42 CDT