Oracle DBA, How To, Error, Cause and Action

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

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