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 - 11:09:19 CDT
