Re: Moving a large # of rows from one table to another ?

What about a commit after each of the row inserts into the history table and using truncate to drop the rows from the old table ?

Richard Elliott wrote:

> I have a table that contains many millions of rows. To keep it from growing
> too large I move data off of it to a history table that is not used
> directly and has very few indexes on it. In order to get this to work I had
> to do a very low level move (copy & delete) to avoid rollback segment
> errors. Now that it works it takes a very long time, more time that I have
> in a given window. Is there a utility, or a beter way to do this. It's the
> delete part of the process that demands the huge amount of rollback space
> if not done at a very low level. Once the data has been inserted into the
> backup table I don't care if the delete is rollbackable, can this be turned
> off for a session or a transaction ?
>
Received on Tue May 25 1999 - 12:13:54 CDT