cancel
Showing results for 
Search instead for 
Did you mean: 

Problem when creatting ROLLBACK SEGMENT on windows/oracle

Former Member
0 Kudos
67

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)

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member618758
Active Participant
0 Kudos

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
0 Kudos

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.