RE: Question re: TRUNCATE ... REUSE STORAGE
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 2 Jul 2004 11:44:53 -0400
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
storage" means that extents beyond the minimum extent setting is returned to
Oracle as free space.
HTH -- Mark D Powell --
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Leslie Tierstein
Sent: Friday, July 02, 2004 11:37 AM
To: oracle-l
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?
(Sorry, don't have an environment set up right now in which I can test.)
Leslie Tierstein
Senior Consultant
Vision Chain, Inc.
The first software to power the demand data network
phone: 202-261-3549
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
