Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Resizing Datafile
Hello !
I have problem with resizing a datafile. It belongs to tablespace, that
contains indexes. Thanks to informations in view DBA_FREE_SPACE I know that
it contains
free space and I want to make it a little smaller.
But when I'm executing command:
ALTER DATABASE DATAFILE 'filename' RESIZE new size
where new size, is not smaller than (current size) minus (free space in file)
i receive message:
ORA-03297:file contains 22875 blocks of data beyond the requested RESIZE value
What is important, sum of this value (22875) and my requested resize value
is equal to current
file size. In this moment I understand that a free space in file means
nothing for this operation.
It is possible to do so ? What schould I do ?
I thank in advance for a responce
Versions:
RDB Oracle Workgroup Server 7.3.2.3 fot WIN NT
Received on Thu Oct 14 1999 - 02:09:13 CDT