Re: Rollback segment errors

Without knowing your database, I can offer you only three major things to try. First one (try first): Assuming this is a huge import... when you use imp, use the option COMMIT=Y. for example:
imp system/manager commit=y

Second One: Set the parameter UNLIMITED_ROLLBACK_SEGMENTS = TRUE in your init<sid>.ora file. Then alter your rollback segments to have a greater max extent: ALTER ROLLBACK SEGMENT "R01" STORAGE ( MAXEXTENTS 256 );

Third Thing: If all else fails...create bigger rollback segments. If you have the room, why the hell not?

Good Luck,
Satar Naghshineh

In article <19980917191716.03753.00000249_at_ng62.aol.com>,   coolbowtie_at_aol.com (Coolbowtie) wrote:
>
> I keep getting a rollback segment error when trying to import new tables. I an
> not too familiar with Oracle at all, but if someone could try to tell me what
> that errror means it would help me to try to start to fix this problem.
>
> Also I get another error that says max number of extents reached 121. What does
> that mean?
>
> If anyone could at least define these messages it would help me to try an start
> to fix it.
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Fri Sep 18 1998 - 19:12:14 CEST