Purpose of Query
The query will provide the list of source file objects that does not belong to a snapshot
Applicable CAST Version
Release | Yes/No |
---|---|
8.3.x | |
8.2.x | |
8.1.x | |
8.0.x | |
7.3.x |
Applicable RDBMS
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS2 |
Query for CSS
SELECT dot.OBJECT_TYPE_NAME, dos.OBJECT_FULL_NAME FROM DSS_OBJECTS dos LEFT JOIN DSS_OBJECT_INFO doi ON doi.OBJECT_ID = dos.OBJECT_ID AND doi.SNAPSHOT_ID = 2 JOIN DSS_OBJECT_TYPES dot ON dot.OBJECT_TYPE_ID = dos.OBJECT_TYPE_ID WHERE lower(dot.OBJECT_TYPE_NAME) LIKE '%source file%' AND doi.OBJECT_ID IS NULL ORDER BY 1;
Query result example
Query result interpretation
The query will provide the list of source file objects that does not belong to a snapshot
Query for Oracle
Same as CSS2
Query result example
Query result interpretation
Query for SQL server
Same as CSS2
Query result example
Query result interpretation
Notes/comments
Related Pages