Update Command in Huge data

[Former Member]

Hello All,

I am executing following simple SQL Command which will execute almost 10 million records.

update "ECCSLTR2"."sales"

set column_0 = replace (column_0,'|',',')

But above command is failed due to internal memory issue.

is there any other way to execute this command like batch wise execution

Thanks

Jagan

[rama_shankar3]

Jagan,

Adding to Ravi's comments, use some additional condition in the udpate statement with where clause.

i.e:

update "ECCSLTR2"."sales"

set column_0 = replace (column_0,'|',',')

where column1 = 'val1'

Good luck

Rama

[former_member184768]

Hi Jagan,

Can you please try with setting AUTO COMMIT OFF. Alternatively, you can try with different sets of data based on other column (like region / country / any character which can split data into multiple sets) and try updating.

Regards,

Ravi