SQL&gt; alter database datafile &#39;D:\ORACLE\MY0208.DBF&#39; resize 1000M;<br />alter database datafile &#39;D:\ORACLE\MY0208.DBF&#39; resize 1000M<br />*<br />ERROR 位于第 1 行:<br />ORA-03297: 文件包含在请求的 RESIZE 值以外使用的数据<br /><br />我在回收数据的时候出现了这个提示，大家帮我看看原因，谢谢啦

因为已经分配的extents超过了1000M的大小

solution 1: (maybe affects online users)<br /><br />export all objects on TS1<br />truncate all objects on TS1<br />resize TS1<br />import all objects back to TS1<br /><br /><br />solution 2: (does not affect online users)<br /><br />move all objects on TS1 to TS2<br />resize TS1<br />move all objects back TS1<br /><br />e.g. For tables:<br /><br />SQL&gt; set heading off<br />SQL&gt; spool c:\aaa.sql<br />SQL&gt; select &#39;alter table &#39;||owner||&#39;.&quot;&#39;|| table_name ||&#39;&quot; move tablespace TS2;&#39; from dba_tables where tablespace_name=&#39;TS1&#39;;<br /><br />For index:<br />SQL&gt; set heading off<br />SQL&gt; spool c:\bbb.sql<br />SQL&gt; select &#39;alter index &#39;||owner||&#39;.&quot;&#39;|| index_name ||&#39;&quot; rebuild tablespace TS2;&#39; from dba_indexes where tablespace_name=&#39;TS1&#39;;<br /><br />**keep the spooled files so that you can re-edit it and move objects back<br />