My Oracle Support Banner

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

Last updated on AUGUST 31, 2020

Applies to:

Oracle Communications ASAP - Version 7.0.0 and later
Information 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


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