Purpose of Query
The query provides the list of source file objects that 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
JOIN DSS_OBJECT_INFO doi
ON doi.OBJECT_ID = dos.OBJECT_ID
AND doi.SNAPSHOT_ID = <SNAPSHOT_ID>
JOIN DSS_OBJECT_TYPES dot
ON dot.OBJECT_TYPE_ID = dos.OBJECT_TYPE_ID
WHERE lower(dot.OBJECT_TYPE_NAME) LIKE '%source file%'
ORDER BY 1
Query result example
Query result interpretation
The query will result the number of sources files included for 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
