Solution depends on the following:
- Space availability?
- Is table partitioned?
- What percentage of the table will be deleted?
- Number of indexes?
- Solution based on CTAS (create temporally table):
CREATE TABLE <temp table> AS
FROM <source table>
DROP <source table>;
RENAME < temp table> to <source table>;
- Solution based on rowid and blocks:
< in progress>