Re: Rollback Seg problem.

Is there only one rollback segment involve with that corrupted datafile? If it is the case, try to bring that rollback segment offline first. Then shutdown the database and remove that particular rollback segment from your init.ora file. I guess is that you havn't change the init.ora file and that rollback segment is still in the parameter "rollback_segments". After you get rid of it in the init.ora file. Open the database. Make sure that the rollback segment is offline, then drop the rollback segment.

If you are still unsucessful in dropping the rollback segment. Try to create another tablespace for rollback segment and add a few rollback segment in that tablespace. Add those rollback segments in your init.ora file (remember to remove the old one!). and bring that rollback segment offline. Close the database and restart it. Then drop the whole tablespace which the corrupted rollback segment resigns in.

Hope it can help!

Winnie Liu

In article <35C9D081.23B35A3A_at_non-hp-usa-om46.om.hp.com>,   michael_rothwell_at_non-hp-usa-om46.om.hp.com wrote:
> I get an error on a file being corrupt. I traced the file
> down to the file that the rollback segment is in. I created
> a new rollback seg and placed it on line, shut down the db
> and restarted it. I am trying to drop the old rollback seg
> but it is still being used. I tried to start the db without
> mounting/opening. I still could not drop the rollback seg.
> What do I need to do.
> This is a test system, so it's not mission critical.
>
> NT 4.0 box
> RDBMS 7.3.x
>
> Thanks.
>
> Michael.
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Aug 06 1998 - 14:55:15 CDT