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);
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:
Post a Comment