Fast Oracle Table deletion without using TRUNCATE TABLE
Posted on 2010-03-24
Please suppose you have to delete 99,50 % of the records of an Oracle Table.
You cannot use TRUNCATE.
You have a particular where condition to use, you can't delete randomly of course!
Could you suggest me an efficient way to delete the records?
Please suppose you have a massive table, with million of records.