Friday, September 2, 2016

ORA-01630: max # extents (4096) reached in temp segment in tablespace HARVEY

ERROR at line 1:
ORA-01630: max # extents (4096) reached in temp segment in tablespace HARVEY

The solution is

Get the maximum extents and either increase the value to something bigger or make it unlimited.

select tablespace_name, min_extents, max_extents from DBA_TABLESPACES order by 1;

SQL> alter tablespace HARVEY default storage (maxextents unlimited);

No comments: