Help - Timeout when updating 190 million row table

microsoft.public.dotnet.framework.adonet

4 Apr 2006 7:31 PM

Mori

I am using a web service as my data access tier and trying to update several
(43) related tables in an Oracle data warehouse. The problem is that one of
the tables has over 190 million records. the field being updated is one of
the keys.

I am using ADO.NET 2.0. The entire operation is timing out. is there any
way I can do this?

Any suggestions appreciated.