SAP Note 16277 - ORA1562 / ORA1628

Symptom:

A transaction that processes mass data (import, client copy) terminates with the following error messages:
ORA1562 failed to extend rollback segment (id = %s)
ORA1628 max # extents (%s) reached for rollback segment %s

Cause and prerequisites

The storage parameter "maxextents" for the rollback segments is defined too small for the transaction that terminated.

Solution
Change storage parameter "maxextents" for all rollback segments (usually: prs_1, prs_2,... , prs_10):

sqldba lmode=y
SQLDBA> connect internal
SQLDBA> alter rollback segment storage (maxextents 300);
SQLDBA> exit

Additional key words

PSAPROLL