Re: cannot resize a tablespace

From: Roland Schaar <rschaar_at_gosch.com>
Date: Fri, 17 Sep 1999 08:32:17 +0100
Message-ID: <37E1EE81.DF1F9EA7_at_gosch.com>


[Quoted] Hello Jorge!

Following statement will reorganize the tablespace. It' s a kind of defrag of [Quoted] empty blocks.

alter tablespace <TABLESPACE> coalesce;

roland schaar
Gosch Consulting GmbH

Jorge wrote:

> Hi, Can I truncate a tablespace like a table??, or can I defrag it and then
> truncate ??
Received on Fri Sep 17 1999 - 09:32:17 CEST

Original text of this message