SQL Queries - CAST Central Base - Corruptions on Data Function - How to list and clean the objects that are part of Data Function but not part of snapshot

Created by Amine Benarbia on Feb 11, 2022
Purpose of Query

This query lists then cleans the objects that are part of Data Function but not part of the snapshot.

Applicable CAST Version
Release
Yes/No
8.2.x(tick)
8.1.x(tick)
8.0.x(tick)
Applicable RDBMS
RDBMS
Yes/No
Oracle Server(question)
Microsoft SQL Server(question)
CSS2(tick)
Query for CSS
SELECT snapshot_id, 
       object_id 
FROM   efp_DF_info 
WHERE  object_id NOT IN (SELECT object_id 
                         FROM   dss_object_info)
Query result example
2,665414
Query result interpretation
 The query returns the snapshot ID and the object ID of a Data Function.

In this example the object ID equal to 665414 is part of a Data Function but is not part of the snapshot of ID equal to 2

In order to clean this corruption run the following query:

DELETE FROM efp_DF_info 
WHERE  object_id NOT IN (SELECT object_id 
                         FROM   dss_object_info);
Query for Oracle
Enter the SQL query
Query result example
 
Query result interpretation
 
Query for SQL server
Enter the SQL query
Query result example
 
Query result interpretation
 
Notes/comments
 

 

 

Related Pages