ORA-01630 : max # extents (extent) reached in temp segment

December 2016






ORA-01630 : max # extents (extent) reached in temp segment in tablespace name_tab_space

It may be due to the fact that a temporary segment is trying to extend MAXEXTENTS.
TO solve this, if MAXEXTENTS for the tablespace is less than the maximum limit of the system, you can raise or increase the PCTINCREASE for the target tablespace

Related :

This document entitled « ORA-01630 : max # extents (extent) reached in temp segment » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.