PL/SQL (MOSC)

MOSC Banner

Managing table rows using procedure

edited Jun 22, 2020 12:26PM in PL/SQL (MOSC) 5 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center