Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Resizing Datafile

Resizing Datafile

From: Daniel Wiechczyński <D.Wiechczynski_at_um.zielona-gora.pl>
Date: Thu, 14 Oct 1999 07:09:13 GMT
Message-ID: <tkfN3.7958$%3.136158@news.tpnet.pl>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US