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

April 2018






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
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 (https://ccm.net/).
Start a database with a missing data file
Oracle - Resetting a sequence