Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: cannot resize a tablespace

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@gosch.com>


Hello Jorge!

Following statement will reorganize the tablespace. It' s a kind of defrag of 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 - 02:32:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US