Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Resize Datafile
Josef Huber wrote:
>
> 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
As the message suggests some part of some object still resides above the 200m mark in the file...Either change 200m to be larger or possibly look at reorging/dropping/moving the offending objects
HTH
--