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_at_herald.ctp.com>
Date: Tue, 21 Sep 1999 13:46:29 +0530
Message-ID: <7s7eq3$ldp$1_at_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 - 10:16:29 CEST