Re: Rollback Segment Error

>Also, I tried to take the rollback segment offline and online again,
>but its status has been 'PENDING OFFLINE' for quite sometime even
>though I am not doing any updates currenly. It seems to me that for some
>reason the rollback segment is not being cleared. Can it be because the
>process that used the rollback segment was not completed successfully
>before it committed or rollbacked the transaction?
>
>Any ideas???
>

If you don't mind losing any transactions that may be in that rollback segment, do this:  

Shutdown database. (You may have to do a shutdown abort) put _offline_rollback_segments=( your_rollback_segment_name_here ) in your

    init.ora file
startup
drop the rollback segment  

If the _offline_rollback_segments does not work, you may have to go one step further and say _corrupted_rollback_segments  

That should do the trick.

-- 
                     ------------------------------------
If you have a condom and sunscreen SPF 15 or greater, than it's safe to look at
                     http://www.panix.com/~gsa/index.html