Archives of the TeradataForum
Message Posted: Sat, 08 Dec 2012 @ 13:01:19 GMT
There are 2 things here...
1. Please check if there are rows before the start date of your delete...i.e <'2010-01-01' [Data will not be deleted in this case.. you will have to delete all data before the start date and try again...]
2. Make sure you are giving the exact parttion range for delete, as those were creaeted as part of CREATE TABLE statement.
Thanks and Regards,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|