Re: Resize Datafile

From: Hilary Shreter <shreterh_at_orau.gov>
Date: Wed, 23 Sep 1998 12:48:57 -0400
Message-ID: <36092687.0@198.125.67.246>

Sounds like you're trying to "downsize" that file and there's data beyond your proposed resize value.

If you can't live with a larger value than 200M, then you'll have to reorganize the tablespaces or coalese or whatever it takes to get that space usage down.

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 - 11:48:57 CDT