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

January 2017






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


Published by jak58. Latest update on July 1, 2009 at 03:57 AM by jak58.
This document, titled "ORA-01630 : max # extents (extent) reached in temp segment," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).