Updating a table
Asked: November 10, 2002 - pm UTC Answered by: Tom Kyte - Last updated: May 10, 2019 - am UTC Category: Developer - Version: 8.1.7 Viewed 100K times! One of our apps updates a table of several hundred million records. For loop approach for the update was calculated to take 53.7 years to complete!
We institued the Insert into a dummy table append with nologging, and were able to complete the "update" in under 30 minutes.
This was a totally new paradigm for the application, and one that saved the entire mission-critical application.Since the Styles control the formatting of the entries in the Table of Contents, we need to modify the Styles to correct the formatting.The first entry that has incorrect formatting is TOC 2 (the second-level entries).But what happen to dependent objects ,everything will get invalidated. We've a similar situation., We delete around 3 million records from 30 million rows table everyday.Yeah ,of course it'll recompile itself when it called next time. There is no logical column to do partition., I guess the insert into a new table will take considerable time with 27 mil records.. November 12, 2002 - am UTC wait 10 days so that you are deleting 30 million records from a 60 million record table and then this will be much more efficient. 3 million records on an indexed table will take considerable time.
Since you can't list more than one table in the Oracle UPDATE statement, you can use the Oracle EXISTS clause.