My Oracle Support Banner

Usage Of These Delete Statements-Needed For Cyber Security Reasons (Doc ID 3038374.1)

Last updated on AUGUST 05, 2024

Applies to:

Currency Transaction Reporting - Version 8.0.0 and later
Information in this document applies to any platform.

Goal

Below delete statements ran in our DB during off business hours. Could be during a restart.Please confirm what these tables are used for and these deletes are regular occurance ?
This is a query from Our Cyber Defence team and wanted to provide justification on the same.

DELETE FROM date_task_master WHERE v_info_domain = :'**0' and v_task_id = :'**1'
DELETE FROM date_task_step_precedence WHERE v_info_domain = :'**0' and v_task_id = :'**1'
DELETE FROM pr2_rule_map_pr pr
delete from pr2_rule_map_pr_tmp tmp
DELETE FROM pr2_rule_map_exclude_pr ex
delete from pr2_rule_map_exclude_pr_tmp tmp
DELETE FROM PR2_COMP_DEF_LIST_PR PCDL
DELETE FROM pr2_rule_map_pr pr
delete from pr2_rule_map_pr_tmp tmp
DELETE FROM pr2_rule_map_exclude_pr ex
delete from pr2_rule_map_exclude_pr_tmp tmp
DELETE FROM PR2_COMP_DEF_LIST_PR PCDL

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.