Delete sets of rows on demand
Hello,
I need to create a process to delete a set of rows based on time and that can be run on demand.
The process needs to get all the records that have a creation date older than the date provided and delete them.
It needs to be an online process, without service interruption.
The amount of rows to be deleted per maintenance can be between 200,000 to 5'000,000 rows.
The average row length is 628Bytes.
I was thinking that using PL/SQL could help me with this, I would have:
- Retrieve all the IDs in a cursor.
- For the delete, have a loop to delete one by one the records:
I need to create a process to delete a set of rows based on time and that can be run on demand.
The process needs to get all the records that have a creation date older than the date provided and delete them.
It needs to be an online process, without service interruption.
The amount of rows to be deleted per maintenance can be between 200,000 to 5'000,000 rows.
The average row length is 628Bytes.
I was thinking that using PL/SQL could help me with this, I would have:
- Retrieve all the IDs in a cursor.
- For the delete, have a loop to delete one by one the records:
0