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 -> Re: Resize Datafile

Re: Resize Datafile

From: Connor McDonald <mcdonald.connor.cs_at_bhp.com.au>
Date: Tue, 22 Sep 1998 18:12:20 +0800
Message-ID: <36077804.3F0B@bhp.com.au>


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
--



Connor McDonald
BHP Information Technology
Perth, Western Australia
"The difference between me and a madman is that I am not mad" Received on Tue Sep 22 1998 - 05:12:20 CDT

Original text of this message

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