Re: Rollback segment errors

Rollback segments have storage parameters like initial size, next site, maximum extents, optimal, etc.
The default maximum number of extents that can be allocated is 121. So you've maxed out
that rollback segment.

You should try the import using a parameter file and adding the line: commit=y

This will commit after each row (i think it's row) of data is imported & should solve
your problem. However, you might need to look at your rollback segments and see if you've run out of extents & fix that.

Stephanie

Coolbowtie wrote in message <19980917191716.03753.00000249_at_ng62.aol.com>...
>
>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.
Received on Fri Sep 18 1998 - 08:15:42 CEST