• copy the table to another table and then truncate the old table