It would be a major change to ALL TRANSACTIONAL SYSTEMS.
You do not want what you ask for (trust me, you don't).
Suppose the delete "failed" halfway through (constraint violation, system
failure, whatever).Now what do you have?Total, 100% loss of data integrity
-- that is what.
In order to do what you want (sort of), I generally recommand:
create table as select-- using paralle and
unrecoveral.
direct path load or insert /*+ append */ (same thing basically) the new data
index in parallel, with unrecoverable as well
drop the old table
rename the new table
BACKUP
There you go -- very fast, very efficient -- results in "compact data" (whereas
a delete would leave lots of free space).No logging, no undo -- just what you
think you need.
|