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

Are you running Oracle8? You could do something with partitioning if you were.

Jonathan

On Tue, 25 May 1999 16:09:19 GMT, "Richard Elliott" <Richard.A.Elliott_at_WGP.TWC.COM> 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 Wed May 26 1999 - 14:58:31 CDT