Re: How to shrink data file

From: N.N. <asko.makitalo_at_elomatic.com>
Date: Fri, 02 Feb 2001 08:06:07 GMT
Message-ID: <PTte6.24$xv5.1886@read2.inet.fi>

Try
alter tablespace system coalesce;
This will coalesces into larger continuous extents and then you might be able to resize.

Regards
Asko

zhang liang wrote in message <95avqf$1mva$1_at_news.cz.js.cn>...
>After checking dba_free_space, I found that "system" tablespace has 1.67G
>free bytes. Since the data file for "system" tablespace is about 2.1G, I
try
>to use the following command to resize file system01.rbf to about 800M:
>
>alter database datafile '/oracle/u01/oradata/wapdb/system01.rbf' resize
>800M;
>
>But the following error message was returned:
>
>ORA-03297: file contains used data beyond requested RESIZE value
>
>
>The same kind of error also occurs when I try to shrink file "rbs01.dbf",
>which holds tablespace "rbs".
>
>
>
>
>
Received on Fri Feb 02 2001 - 02:06:07 CST