How to perform Bulk delete oe optimize delete operation

om.ranjan · Post by **om.ranjan** » Fri Oct 16, 2009 4:56 pm

Hi,

I have to delete million of record every quarter from a database (Purge operation), It will read from file and get unique ID record which need to be deleted from ORACLE database table.

in this regards
How to perform Bulk delete?

Thanks,
Ranjan

ray.wurlod · Post by **ray.wurlod** » Fri Oct 16, 2009 4:59 pm

No such thing if you have to provide selective keys. The best you can do is to find the optimum balance between array size and transaction size. The first will be a function of your row size; the second should be an integer multiple of the first.

ArndW · Post by **ArndW** » Sat Oct 17, 2009 6:15 am

How about partitioning your database according to this key, then a delete operation could involve just removing one or more database partitions.

om.ranjan · Post by **om.ranjan** » Mon Oct 19, 2009 5:42 pm

ArndW wrote:How about partitioning your database according to this key, then a delete operation could involve just removing one or more database partitions. ...

No partitioning has been used.

Thanks,
Ranjan

ArndW · Post by **ArndW** » Tue Oct 20, 2009 1:21 am

Then it would makes sense to talk with your DBAs about enabling partitioning in order to make maintenance, such as this delete, a simple matter.