Dang Mark! We're going to have to rename you "MacGyver"..... ;-) Quoting "Mark W. Farnham" <mwf@xxxxxxxx>:
You can decouple from the time of the run by inflating a table of a different name and using rename. You can mess with pctfree and pctused so you can inflate the table with one row per block, alter pctfree and pctused, and then run the delete. If the target table has its own tablespace you can drop the tablespace and re-transport in the tablespace with the pre-inflated empty table.
-- //www.freelists.org/webpage/oracle-l
