can't resize datafile even though it has no objects!
Hi all,
My meagre search skills have not been able to find an answer to this question, so thought I'd better post it here. Sorry if it's been answered before.
I have moved all the objects out of a specific data file, which is currently 34G in size. I would think that this would allow me to resize it to minimum, but it does not, as follows ...
Does anyone have any ideas on why I can't resize this data file?
Thanks
Callum
SQL> ! ls -ltar /mnt/nfs/home/oracle/users01.dbf
-rwxr--r-- 1 oracle dba 34359730176 Jun 18 14:10 /mnt/nfs/home/oracle/users01.dbf
SQL> select count(*) from dba_extents a, dba_data_files b where a.file_id = b.file_id
2 and b.file_name = '/mnt/nfs/home/oracle/users01.dbf' ;
COUNT(*)
----------
0
SQL> alter database datafile '/mnt/nfs/home/oracle/users01.dbf' resize 10g ;
alter database datafile '/mnt/nfs/home/oracle/users01.dbf' resize 10g
*
ERROR at line 1:
ORA-03297: file contains used data beyond requested RESIZE value
SQL>