Page 1 of 1
How to perform Bulk delete oe optimize delete operation
Posted: Fri Oct 16, 2009 4:56 pm
by om.ranjan
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
Posted: Fri Oct 16, 2009 4:59 pm
by ray.wurlod
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.
Posted: Sat Oct 17, 2009 6:15 am
by ArndW
How about partitioning your database according to this key, then a delete operation could involve just removing one or more database partitions.
Posted: Mon Oct 19, 2009 5:42 pm
by om.ranjan
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
Posted: Tue Oct 20, 2009 1:21 am
by ArndW
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.