Purpose of Query
This page helps you to get the list of objects not linked in DSS_LINK_INFO table.
Applicable CAST Version
Release | Yes/No |
|---|---|
| 8.3.x |  |
| 8.2.x | |
| 8.1.x |  |
| 8.0.x | |
Applicable RDBMS
RDBMS | Yes/No |
|---|---|
| Oracle Server | |
| Microsoft SQL Server | |
| CSS2 | |
Query for CSS
SELECT O.OBJECT_TYPE_ID,
COUNT(O.OBJECT_ID)
FROM DSS_OBJECT_INFO O
JOIN DSS_OBJECT_TYPES OT
ON OT.OBJECT_TYPE_ID = O.OBJECT_TYPE_ID
AND OT.OBJECT_GROUP = 2
WHERE O.SNAPSHOT_ID = 104
AND NOT EXISTS ( SELECT 1
FROM DSS_LINK_INFO DL
WHERE DL.LINK_TYPE_ID = 2
AND DL.SNAPSHOT_ID =<snapshot_id>
AND DL.NEXT_OBJECT_ID = O.OBJECT_ID
)
Group by O.OBJECT_TYPE_ID
Query result example
Query result interpretation
Query provides object type id and counts of objects not linked in DSS_LINK_INFO table.
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
