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

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:04:10 CDT