My Oracle Support Banner

Methods For Deleting Orphan Records From Tbl_srq_log (Doc ID 729617.1)

Last updated on MAY 23, 2022

Applies to:

Oracle Communications ASAP - Version 4.7.2 and later
Information in this document applies to any platform.

Purpose

This note aims to answer queries regarding the deletion of orphan records.

Questions and Answers

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
Purpose
Questions and Answers
 Can the query the query below be used to delete records from tbl_srq_log without having an impact on ASAP functionality instead of the query, as the second query is time and resource consuming but both the queries seem to do the same job?
 Can the query the query below be used in ssp_db_admin procedure instead of the resource consuming query to delete records based on date criteria?

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