Managing table rows using procedure
Dear,
One of our transaction table keeps growing. And due to this sql response time increasing. Now,we want to keep minimum number of rows in the table,and rest rows will be stored in archive table.
For example, the main table will always keep last 2 or 3 days data, and all the remaining rows will be storing in archive table. Every day around 6.00 am oracle scheduler will run and a procedure will do the data movement. In the table,there is one column value with unique value.
Cloud you guys suggest what could be the most optimal way to write down the procedure.