Information Regarding Database Maintenance Activity In ASAP (Doc ID 1966864.1)

Last updated on FEBRUARY 04, 2024

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.