ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDO'
- by Nitin Gurram
I am trying to update the table which has millions of records.
However my update query will update around 2-3 millions of records.
I am facing below error on executing the update query.
I googled and found that I need to update the Table Space as DBA
But is there any work around for executing the update without actually extending the UNDO table space or something dba is not required
UPDATESERVICE SET CREATION_TIME = LAST_UPDATE_TIME WHERE CREATION_TIME is null