ORA-30036: unable to extend segment by 8 in undo tablespace 'APPS_UNDOTS1'
Hi Team,
We are purging stats using the below procedure as part of applying timezone upgrade.
SQL> select count(*) from SYS.WRI$_OPTSTAT_HISTGRM_HISTORY;
COUNT(*)
23585522
select count(*) from SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY;
COUNT(*)
32907064
SQL> exec DBMS_STATS.PURGE_STATS(systimestamp);
*
ERROR at line 1:
ORA-30036: unable to extend segment by 8 in undo tablespace 'APPS_UNDOTS1'
ORA-06512: at "SYS.DBMS_STATS", line 47863
ORA-06512: at "SYS.DBMS_STATS_INTERNAL", line 193
ORA-06512: at "SYS.DBMS_STATS_INTERNAL", line 12212
ORA-06512: at "SYS.DBMS_STATS", line 47850
ORA-06512: at "SYS.DBMS_STATS", line 47876
ORA-06512: at line 1
SQL>select count(*) from SYS.WRI$_OPTSTAT_HISTGRM_HISTORY;