Re: Question re: TRUNCATE ... REUSE STORAGE

From: Tanel Põder <tanel.poder.003_at_mail.ee>
Date: Fri, 2 Jul 2004 18:42:00 +0300
Message-ID: <02ba01c4604b$1dace3e0$e8879fd9@porgand>

Hi!

When truncating using REUSE STORAGE, the HWM is reset to zero and the extent information in segment headers extent map is also kept. With DROP STORAGE option the HWM is reset to zero and extent map is cleared up to minextents of the segment.

Tanel.

Original Message ----- From: "Leslie Tierstein" <Leslie.Tierstein_at_visionchain.com> To: "oracle-l" <oracle-l_at_freelists.org> Sent: Friday, July 02, 2004 6:37 PM Subject: Question re: TRUNCATE ... REUSE STORAGE

> I have RTFM'ed:
>
> Oracle 9.2.0.4: SQL Reference, TRUNCATE command:
>
> REUSE STORAGE
> Specify REUSE STORAGE to retain the space from the deleted rows allocated
to
> the table or cluster. Storage values are not reset to the values when the
> table or cluster was created. This space can subsequently be used only by
> new data in the table or cluster resulting from insert or update
operations.
> This clause leaves storage parameters at their current settings.
>
> Does this mean that the high-water mark is not reset? i.e., that a DIRECT
> LOAD or INSERT ... APPEND will *NOT* use the space previously used by the
> deleted rows?
>

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 - 10:38:44 CDT