From: "N.N." Newsgroups: comp.databases.oracle.server References: <95avqf$1mva$1@news.cz.js.cn> Subject: Re: How to shrink data file Lines: 32 X-Newsreader: Microsoft Outlook Express 4.72.2106.4 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4 Message-ID: Date: Fri, 02 Feb 2001 08:06:07 GMT NNTP-Posting-Host: 194.252.145.120 X-Trace: read2.inet.fi 981101167 194.252.145.120 (Fri, 02 Feb 2001 10:06:07 EET) NNTP-Posting-Date: Fri, 02 Feb 2001 10:06:07 EET Organization: Sonera corp Internet services 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@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". > > > > >