There are 16 Million of Records in oracle table 'TBLUSERACTIVITIES'. If I am running below query for 100 records, its updating record successfully. but if running for whole table getting the below error.
Query :
update EAITEMP.TBLUSERACTIVITIES b
set b.EventID1 = (select REGEXP_REPLACE(REGEXP_SUBSTR(a.ACTION, 'Event [0-9]+'),'Event ') as EventId1
from EAITEMP.TBLUSERACTIVITIES a where a.Key =b.Key) ,
b.EventID2 = (select REGEXP_REPLACE(REGEXP_SUBSTR(a.ACTION, 'Event [0-9]+',1,2,'i'),'Event ') as EventId2
from EAITEMP.TBLUSERACTIVITIES a where a.Key =b.Key)
Error report:
SQL Error: ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDO_DATA'
30036. 00000 - "unable to extend segment by %s in undo tablespace '%s'"
*Cause: the specified undo tablespace has no more space available.
*Action: Add more space to the undo tablespace before retrying
the operation. An alternative is to wait until active
transactions to commit.
Need urgent help
Thanks