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

Hi,

    Okay, how about this approach.

1. create a temporary table with the rows you want to keep.
2. update your history table
3. Drop the original table
4. Rename the temporary table and recreate any required constraints.

regards

Jerry Gitomer

Richard Elliott wrote in message
<01bea6e1$0a4810a0$4b03c896_at_isbarae.transco.twc.com>...
>I am not moving all the rows to history, just those older than 24 months,
>truncate will drop all rows from the remaining table not just the ones
>migrated to history. But Thanks Anyway !
>
>Dominic Baines <rdab100_at_cam.ac.uk> wrote in article
><374ADA51.EC0DBA95_at_cam.ac.uk>...
>> 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 ?
>
Received on Tue May 25 1999 - 14:51:28 CDT