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

Hi Richard,

if You have the Enterprise Edition of Oracle8 with the Partitioning Option or higher, You can partition Your table into partitions per time slice. In the docu I have seen some examples for exactly the same problem. But I have never used the partitioning option by myself.

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 ?

--
Best regards

Ralph Ganszky

• The above opinions are mine and do not represent any official
• standpoints of my employer or third-party organizations.