One of the most painful things to do is to delete a huge amount of data. One workaround for this is to export the data needed and then LOAD/REPLACE back into the same table, but this requires an outage of the table to accomplish.
If a WHERE clause could be specified using ADMIN_MOVE_TABLE (or another utility with the same functionality that allows a where clause?), then the outage time could be avoided.
Delete statements take a long time, and even with caution, churn through a lot of transaction logs. Even wrapping them in logic to reduce the rows deleted in a single transaction can risk log space and therefore database availability.
|Who would benefit from this IDEA?||DBAs, trying to maintain availbilty while deleting large amounts of data|
How should it work?
|Priority Justification||There are ways around it, this is just an improvement DBAs would love|