Updating a table
To fix the Table of Contents, I basically replace it.
Yes, there are other ways to modify TOC entries (if you're already comfortable with Styles), but I prefer this method because it doesn't involve me searching all over the document for each Style and modifying it separately. First, we select the entire Table of Contents with the mouse and hit Delete.
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.
I work with John Bittner, one of the previous reviewers. This process was introduced to our environment by a master tuner and personal friend, Larry Elkins.
When done, we swap the partition of original data with the 'dummy' table (the one containing new values), rebuild indexes in parallel, and wha-la! i.e, to update field2 in a table:1) First create your dummy hold table: create table xyz_HOLD as select * from xyz where rownum Hi Tom, As u suggested us to create a new table ,then drop the original table and rename the new table to original table instead of updating a table with millions of records.
If you are at the conference, drop into the Groundbreaker area and say Hello. I want to update and commit every time for so many records ( say 10,000 records). Fortunately, you are probably using partitioning so you can do this easily in parallel -- bit by bit.
Check out all our database development sessions at OOW19 Thanks for the question, Murali. I dont want to do in one stroke as I may end up in Rollback segment issue(s). This is absolutely a viable approach, and one we have used repeatedly.
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).