My Oracle Support Banner

Update large number of rows in a table (Doc ID 268395.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 8.1.7.0 to 10.2.0.1 [Release 8.1.7 to 10.2]
Information in this document applies to any platform.
Information in this document applies to any platform.

Goal

How to efficiently update large number of rows in a large/big table.

Goals
=====
The idea is to have minimum amount of redo generation for this operation.
The amount of rollback generated should also be minimal.

Scenario
=======
We have a table of say 30 million records.
We want to update either say 1 million or 25 million records in this table, then in both situations the solution given below can be used for efficient results.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.