Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Moving a large # of rows from one table to another ?
Try using the SQLPLUS Copy Command. - Ethan
In article <01bea6c8$9db04ec0$4b03c896_at_isbarae.transco.twc.com>,
"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 ?
>
>
--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Tue May 25 1999 - 12:19:37 CDT
![]() |
![]() |