ORA-01659 unable to allocate MINEXTENTS beyond string in tablespace string
This is an Oracle Database Server Message. This can be generated by the Oracle Database when running any Oracle program.
What is the cause of ORA-01659 from Oracle 10g ?
Failed to find sufficient contiguous space to allocate MINEXTENTS for the segment being created.
How to deal with ORA-01659 from Oracle 10g ?
Use ALTER TABLESPACE ADD DATAFILE to add additional space to the tablespace or retry with smaller value for MINEXTENTS, NEXT or PCTINCREASE
Contacting Oracle support services ?
Some messages recommend contacting Oracle Support Services to report a problem. Please go here for more information : Oracle Support.
Linked Error Messages
- ORA-01651 unable to extend save undo segment by string for tablespace string
- ORA-01652 unable to extend temp segment by string in tablespace string
- ORA-01653 unable to extend table string . string by string in tablespace string
- ORA-01654 unable to extend index string . string by string in tablespace string
- ORA-01655 unable to extend cluster string . string by string in tablespace string
- ORA-01656 max # extents ( string ) reached in cluster string . string
- ORA-01657 invalid SHRINK option value
- ORA-01658 unable to create INITIAL extent for segment in tablespace string
- ORA-01660 tablespace ' string ' is already permanent
- ORA-01661 tablespace ' string ' is already temporary
- ORA-01662 tablespace ' string ' is non-empty and cannot be made temporary
- ORA-01663 the contents of tablespace ' string ' is constantly changing
- ORA-01664 Transaction which has expanded the Sort Segment has aborted
- ORA-01665 controlfile is not a standby controlfile
- ORA-01666 controlfile is for a standby database
- ORA-01667 cannot add any more tablespaces: limit of string exceeded