Problem when creatting ROLLBACK SEGMENT on windows/oracle

[Former Member]

When creating ROLLBACK SEGMENT on windows/oracle by

CREATE ROLLBACK SEGMENT rollbig TABLESPACE PSAPROLLBIG

STORAGE (INITIAL 1G NEXT 1G

OPTIMAL 2G)

I get message:

ORA-01659: unable to allocate MINEXTENDS beyond 130 in tablespace PSAPROLLBIG

What does it mean and how to avoid that (by not interfering functionality)

[former_member618758]

Hello Tina,

If the overflow in a DMTS is triggered by a very high value for

NEXT_EXTENT, sometimes you can reduce the NEXT_EXTENT value instead of

extending the tablespace. Of course, the best way is to migrate to Automatic UNDO Management and set retention instead of using rbs, depending on your Oracle version.

If you have access to OSS, please also review OSS note 3155 - Termination due to tablespace overflow, it details the cause and how to avoid that in the future.

You may also review note 3807 for related error messages regarding rollback and undo segments.

Hope this helps, if you found them useful, please do award some points.

Thanks,

George

[Former Member]

Hi Tina,

ORA-01659, "unable to allocate MINEXTENTS beyond %s in tablespace %s"

// *Cause: Failed to find sufficient contiguous space to allocate MINEXTENTS

// for the segment being created.

// *Action: Use ALTER TABLESPACE ADD DATAFILE to add additional space to the

// tablespace or retry with smaller value for MINEXTENTS, NEXT or

// PCTINCREASE

Best Regards,

JC Llanes.