| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: cannot resize a tablespace
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
 |
 |