10.12.10

SAP Note 12351 - ORA1552 cannot use system rollback segment for ...

Symptom:

ORA1552 cannot use system rollback segment for non-system tablespace

Cause and prerequisites

a) No additional rollback segment was defined, or
b) The defined rollback segments were not activated (status: offline)

Solution
a) Define additional rollback segments and enter them in
init.ora --> Parameter rollback_segments
b) Enter the existing rollback segments in init.ora
--> Parameter rollback_segments

Key word: ORA1552

No comments:

Post a Comment