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

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. I figure that this means that there are still
> active transactions in the rollback file. The question is, how do I
> commit these transactions? I really don't care about any data that might
> be in the file. I've tried shutting down the database and bringing it
> back online again but this doesn't help. I got myself into this fix by
> setting autoextend ON...
>
> 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.

Drop your rollbacksegments, create new ones and then resize datafile

Hope it helps Norbert

-- 
=====================================
Norbert Ferstl
DI Forsthuber GmbH
Kohlbauernstr. 17
A-2630 Ternitz, AUSTRIA
Tel: +43 2630 382500
Fax: +43 2630 3825014
<ferstl_at_netway.at>
=====================================