I have a script to update the xmltype specific nodes as part of masking the data. While running the update using updatexml function of Xmltype column getting memory error in oracle.
Update table1
set xmlcolum = updatexml(xmlcolumn,’/row/c41/text()’,’Mask’)
Total rows in that table is 1,154,720
Ora-04030: out of process memory while trying to allocate 33584 bytes