Dear Experts ,
Looking for your help :
We have log table having huge data and these tables are being accessed for each processing :
Table & count :
Tran_log ===> 313776046
Trans_key ===>314127519
Trans_Cache ==>511926762
We tried :
Create backup table with same configuration and move data to backup table.
Delete older data from backup table
Truncate original table
move data from backup to original table.
Drop backup table
This operation needs down time and we are working on 24*7 (without good purging mechanism earlier ) , now it's in place but to delete old data take more time to run purge job.
Is there any other way where we can delete the data without impacting daily business operations.
Thank you for your proposals.