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

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

Re: cannot resize a tablespace

From: Chetan Wagle <cwagle_at_ctp.com>
Date: Tue, 21 Sep 1999 13:46:29 +0530
Message-ID: <7s7eq3$ldp$1@herald.ctp.com>


In oracle 7.3 and above, use the alter database datafile resize ....check it out in oracle manuals.

Rgds,
Chetan

Roland Schaar wrote in message <37E1EE81.DF1F9EA7_at_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 Tue Sep 21 1999 - 03:16:29 CDT

Original text of this message

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