Information Regarding Database Maintenance Activity In ASAP
(Doc ID 1966864.1)
Last updated on FEBRUARY 04, 2024
Applies to:
Oracle Communications ASAP - Version 7.0.0 and laterInformation in this document applies to any platform.
Goal
We want to do Database maintenance activity for the ASAP application. We found that there is a large amount of data in the TBL_SRQ_LOG and TBL_SRT_CTX ASAP tables.
The question is, can we delete these tables and recreate these tables again while keeping the other tables intact? We are going to use shrink command capability for
the other tables. We are not going ahead with deleting and recreating the other tables because we need the data for rollback purpose in our Application.
Will rollback of any order be affected if we delete these tables - TBL_SRQ_LOG and TBL_SRT_CTX?
Will the purging jobs have any impact on the data inside these tables or is there any impact on purging process if we delete these two tables only?
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |
References |