Archives of the TeradataForum
Message Posted: Fri, 18 Feb 2005 @ 10:37:23 GMT
| Subj: || || Re: Deleting the partial rows |
| From: || || Victor Sokovin |
| ||I want to delete a 2 to 6 months old data from a table. for eg. Table has 10000 rows, and we need to delete say 4000 records from the rows
which came in first, we don't have any date field to compare for deleting.|| |
Gosh, that could be difficult. Are there old backups still available? If so, you could restore them to, say, a separate database and use the
MINUS (ALL) operator to identify which rows in the production tables already existed at the time of backup. You could then delete those.