This content has been marked as final. Show 7 replies
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
What is Db version?
OERR: ORA 1659 unable to allocate MINEXTENTS beyond in tablespace
TROUBLESHOOTING GUIDE (TSG) - UNABLE TO EXTEND Errors [ID 1025288.6]
Extent Sizes for Sort, Direct Load and Parallel Operations (PCTAS & PDML) [ID 50592.1]
If this db belong peoplesoft please see:
[OLM] 8.9 Broadcast triggers are failing in Scheduled Job report [ID 636286.1]
$ oerr ora 1659 01659, 00000, "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
Pelase check below this 13 number can be change as 2 9 etc..
MINEXTENTS set the number of minimum extent for any segment that to be created.
MAXEXTENTS set the number of maximum number of extent for any segment that to be allocated.
PCTINCREASE: it take place when two extent are already allocated.it work for third or subsequent extent.
third extent size=last extent size+ pctincrease of last extent size.
Using DBA_FREE_SPACE [ID 121259.1]
I've also just encountered, and solved this. In my case the TS was unable to extend enough to accommodate the new table.
create table fstmpxxSAVER (fstmp number) pctfree 99 tablespace xxSAVER storage (initial 2m next 2m minextents 64)
ERROR at line 1:
ORA-01659: unable to allocate MINEXTENTS beyond 6 in tablespace xxSAVER
-- increased datafile max size to be bigger
1* create table fstmpxxSAVER (fstmp number) pctfree 99 tablespace xxSAVER storage (initial 2m next 2m minextents 64)
**On the command prompt**
1.Make sure data file is not filled up and auto extend is on.
2.Try to add a data file or alter existing data file with auto extend capability and max extents unlimited.
alter database datafile '/..../fiilename.dbf' autoextend on maxsize unlimited;
3.Try de-fragmentation of tablespace that caused the problem.
alter tablespace TBSP1 coalesce;
**If you have TOAD, here is the best possible solution**
1. Go to database icon, click schema browser, set your schema as SYSTEM or SYS, then look for tablespaces tab below.
2. Click on the tablespaces tab, look for the tablespace that caused the problem,click the tablespace.
3. Click Basic Info tab, beneath that find extent management.
4. Click on auto allocate extent sizes.
5. Click OK button.
That`s it Problem is resolved.