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