Re: ALTER DATABASE DATAFILE...ORA-03297...HELP!

From: Hassan Abba <hassan_at_softopt.co.uk>
Date: 1997/10/09
Message-ID: <343CC948.8E739D5F@softopt.co.uk>#1/1

Try:

ALTER DATABASE DATAFILE 'D....' OFFLINE; This can only be done if the media recovery is enabled.

Then try to resize it.

Regards

Hassan Abba
Database Developer/Administrator
Soft Options UK Ltd

John Dunn wrote:

> Greetings:
>
> I'm hoping someone can help me or point me in the right direction..
>
> Here's what I'm trying to do:
>
> I'm trying to resize a datafile in my RBS (Rollback) Tablespace from
> 400M to 150M. When I issue the command
>
> ALTER DATABASE DATAFILE 'f:\mydatafile.dbf' RESIZE 150M
>
> I get the "ORA-03297: File contains 4100 blocks of data beyond requested
> resize value" message. How can I resize the datafile? Or how do I drop it
> and re-create it?
> Thanks for any pointers and/or references to the documentation. I've
> looked but it's rather muddy.
>
> My environment: Workgroup Server 7.3.2 on NT 3.51.
Received on Thu Oct 09 1997 - 00:00:00 CDT