My Oracle Support Banner

Questions on Purge Size and Purge Frequency (Doc ID 2997500.1)

Last updated on JANUARY 23, 2024

Applies to:

Oracle Life Sciences Argus Safety Cloud Service - Version 8.2 and later
Oracle Life Sciences Argus Safety - Version 8.2 and later
Information in this document applies to any platform.


Goal

Question 1:
What does it mean to purging - will records in interchange logs be removed after period specified in the interchange log table?

Question 2:
PURGE_SIZE and PURGE_FREQUENCY_IN_DAYS - Is it right to understand that if either of these conditions are met interchange log table will get purged?

Question 3:
DATA_RETENTION_IN_DAYS column - Where will the retained data be available if need to extract is required?
For Example, if PURGE_FREQUENCY_IN_DAYS is 3 days and DATA_RETENTION_IN_DAYS is 30 days, what happens to the records after 30 days?

Question 4:
PURGE_CONDITION column - How is this column used?

Question 5:
PURGE_USER - Is this a Database user or should this user be created?

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

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