Re: Resize Datafile

From: Pavel Polcar <pavel.polcar_at_berit.cz>
Date: Wed, 23 Sep 1998 15:46:35 +0200
Message-ID: <6uaude$m2q$1@cbu.pvtnet.cz>

Hi,
the message says that there still 5312 blocks filled with valid data somewhere beyond 200 M. If you are sure that the datafile contains less valid data than 200M, you can try to reorganize the tablespace using that datafile (using export/drop/import for all or some tables) and then try again.

HtH,

--
Pavel Polcar
Josef Huber wrote in message <36074976.0_at_news.profinet.at>...
>Hello,
>
>I want to resize a datafile,
>ALTER DATABASE DATAFILE 'C:\ORANT\DATABASE\dat01PROF.ORA' RESIZE 200M;
>
>Error Message:
>ORA-03297 File has 5312 datablocks over the RESIZE-value
>
>What can i do ?
>
>
>Ciao,
>Joe
>
>
Received on Wed Sep 23 1998 - 08:46:35 CDT