Re: TRUNCATE v DROP TABLE question

On Sat, 02 Feb 2002 04:14:16 GMT, gl <jogret_at_hotmail.com> wrote:

>Now doing the drop table would be very close to the truncate (DDL also),
>except it will do one other thing, it will remove all the structures.
> That means it will release all the extents that are allocated to the
>table as well as the indexes, and the data will go the same route as the
>truncate (non-recoverable & immediate). The bad thing with this that
>everything in the tablespace will be release, and when you go redefining
>the table, you'll get extents that are available and not necessarily
>what was used last. This could lead to a fragmentation problem in your
>tablespace.

consider TRUNCATE TABLE <tab> REUSE STORAGE;

=> data will be trucated, but extents remain allocated  

regards
Marc Blum
mailto:marc_at_marcblum.de
http://www.marcblum.de Received on Sun Feb 03 2002 - 11:28:20 CST