Purpose of Query
This query lists and cleans the objects that are part of the transaction but not part of the snapshot.
Applicable CAST Version
Release | Yes/No |
---|---|
8.2.x | |
8.1.x | |
8.0.x |
Applicable RDBMS
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS2 |
Query for CSS
SELECT snapshot_id, object_id FROM efp_tran_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 Transaction.
In this example the object ID equal to 665414 is part of a Transaction 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_tran_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