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
How to perform Bulk delete oe optimize delete operation
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
How about partitioning your database according to this key, then a delete operation could involve just removing one or more database partitions.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>