Oracle DBA, How To, Error, Cause and Action

ORA-01659: unable to allocate MINEXTENTS beyond string in tablespace string

ORA-01659: unable to allocate MINEXTENTS beyond string in tablespace string


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

No comments:

Post a Comment

Thanks for your comment.