Paul Huang, July 03, 2001 - 1:46 pm UTC
I am kind of disappointed to the answer to the question 1. Oracle should allow users to reorganize data efficiently when we need to get rid of some junks.
Tom made a correct guess on the question 2. It worked like a chime now. The limit is on the server side, not as I guessed on the client.
Paul Huang, July 04, 2001 - 12:32 am UTC
Well, Tom, not all tables are the same.
We have a billing system that downloads activities from our applications across the nation. We use a table to hold the original records from which we generate summary reports. Based on the agreement with our clients, we keep the original records on billing system for certain days -- some may want 90 days, some want 120 days, some even want 360 days. So each week, we need to purge millions of rows. Yet the table has no relationships to any other tables in the system. If it fails during the operation, just re-issue the delete statement again. No data integrity is violated. No transaction is to worry about. Because it's simply a stand alone table.
KP, July 04, 2001 - 12:49 am UTC
In the case of insert u said
direct path load, an initial create or rebuild and so on can be done in a
non-logged fashion. With these operations, if we fail in the middle - we don't
care -- just drop the affected object."
In the case insert u can do it with non-logged fashion.
Why not the samething can be applied to delete. Even
if delete fails 1/2 way or after 99.99% undo it.
How it is to be done is to be viewed at architectural
What i mean to say is what can be done for insert can be done delete and update.
Wheteher the database architecture
supports it or not is different issue.
I think Tom might have mentioned Direct load insert and nologging
Ravi Ammamuthu, July 04, 2001 - 8:52 pm UTC
There is no way of doing the nologging operations for conventional insert. It is as same as any DELETE or UPDATE operations. Only DIRECT-LOAD insert can be done with nologging. I think, TOM might have mentioned that.
Thanks for insights on NOLOGGING
Pavan Kumar, May 24, 2005 - 10:43 pm UTC
Thanks AskTom Team for providing the insights on NOLOGGING mode. I'll have to try all the situaltions before taking a concrete methodology for my problem.
A reader, October 25, 2006 - 1:20 pm UTC