[Home] [Help] [Dependency Information]
Object Name: | DBA_CUBE_DEPENDENCIES |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
OLAP metadata dependencies in the database
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (128) | Yes | Owner of the dependent metadata object |
D_TOP_OBJ_NAME | VARCHAR2 | (128) | Yes | Name of the top-level object of the dependent metadata object |
D_SUB_OBJ_NAME1 | VARCHAR2 | (200) | Name of the first sub-object of the dependent metadata object | |
D_SUB_OBJ_NAME2 | VARCHAR2 | (200) | Name of the second sub-object of the dependent metadata object | |
D_SUB_OBJ_NAME3 | VARCHAR2 | (128) | Name of the third sub-object of the dependent metadata object | |
D_SUB_OBJ_NAME4 | VARCHAR2 | (128) | Name of the fourth sub-object of the dependent metadata object | |
D_OBJ_TYPE | VARCHAR2 | (25) | Type of the dependent metadata object | |
P_OBJ_OWNER | VARCHAR2 | (30) | Yes | Owner of the referenced metadata object |
P_TOP_OBJ_NAME | VARCHAR2 | (30) | Yes | Name of the top-level object of the referenced metadata object |
P_SUB_OBJ_NAME1 | VARCHAR2 | (30) | Name of the first sub-object of the referenced metadata object | |
P_SUB_OBJ_NAME2 | VARCHAR2 | (30) | Name of the second sub-object of the referenced metadata object | |
P_SUB_OBJ_NAME3 | VARCHAR2 | (30) | Name of the third sub-object of the referenced metadata object | |
P_SUB_OBJ_NAME4 | VARCHAR2 | (30) | Name of the fourth sub-object of the referenced metadata object | |
P_OBJ_TYPE | VARCHAR2 | (23) | Type of the referenced metadata object | |
DEPENDENCY_TYPE | VARCHAR2 | (26) | Type of the dependency relationship |
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, D_TOP_OBJ_NAME
, D_SUB_OBJ_NAME1
, D_SUB_OBJ_NAME2
, D_SUB_OBJ_NAME3
, D_SUB_OBJ_NAME4
, D_OBJ_TYPE
, P_OBJ_OWNER
, P_TOP_OBJ_NAME
, P_SUB_OBJ_NAME1
, P_SUB_OBJ_NAME2
, P_SUB_OBJ_NAME3
, P_SUB_OBJ_NAME4
, P_OBJ_TYPE
, DEPENDENCY_TYPE
FROM SYS.DBA_CUBE_DEPENDENCIES;
|
|
|