SQL Queries - CAST Central Base - Queries on snapshots - How to manually populate DSS_VIOLATION_STATUSES table for a given snapshot

Purpose of Query

The page details the process to populate the table, when a snapshot is missing from the DSS_VIOLATION_STATUSES table in CB.

Applicable CAST Version

Applicable RDBMS

Query for CSS

When a Snapshot is missing from the DSS_VIOLATION_STATUSES table in CB, run the following statement to populate this table:

set search_path=XXX_central;
select ADG_COMPUTE_VIOLATION_STATUSES(<SNAPSHOT_ID>);

Query for Oracle

N/A

Query for SQL server

N/A

Notes/comments

Query result example