issues
search
gajoseph
/
purge
Purge data from db based on datafield(createdDate/ lastupdatedate)
GNU General Public License v3.0
1
stars
0
forks
source link
Pick topmost level parent record and see if it can be deleted
#1
Open
gajoseph
opened
6 years ago
gajoseph
commented
6 years ago
from DButils; get the top most table and drill down recursively thru each child table row;
Copy/ create the child/ parent tables into a destination DB.
Copy rows that are getting deleted w/ some processed time/ process id
create another table that has logs of summarized data of what/ how/ who/when/ how many got deleted
what: tablename
how: what process name
who: what process name
when : date_time
how many rows: # of deleted by process
Have a process to restore the data back to source. set a flag that state the status of row(
A
rchived/
R
estored)
List of index that need to be rebuild in sources/ useless indexes and so on already in dbutils
List of tables w/ high water mark; lot of scattered blocks
from DButils; get the top most table and drill down recursively thru each child table row;
Copy/ create the child/ parent tables into a destination DB.
Copy rows that are getting deleted w/ some processed time/ process id
create another table that has logs of summarized data of what/ how/ who/when/ how many got deleted
how many rows: # of deleted by process
Have a process to restore the data back to source. set a flag that state the status of row(Archived/Restored)
List of index that need to be rebuild in sources/ useless indexes and so on already in dbutils
List of tables w/ high water mark; lot of scattered blocks