Archives of the TeradataForum
Message Posted: Thu, 10 Mar 2005 @ 18:44:39 GMT
<-- Anonymously Posted: Thursday, March 10, 2005 13:10 -->
You can try below options.
Deleting using MLOAD where you won't face roll back problems and its fast too.
Insert the necessary records into a new table and drop the old table. This is also fast approach.
You can otherwise check the options for dropping partitions of a table if possible. By the way V2r6 has got a new option of terminating rollback transactions.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|