SELECT
sch.physicalname owner
, cub.physicalname cube_name
, cwm$util.cube_invalid(cub.irid) invalid
, cub.displayname display_name
, cub.description description
FROM
dba_users u
, cwm$model sch
, cwm$cube cub
WHERE u.username = sch.physicalname
AND sch.irid = cub.datamodel_irid
WITH READ ONLY
SELECT
SCH.PHYSICALNAME OWNER
, CUB.PHYSICALNAME CUBE_NAME
, CWM$UTIL.CUBE_INVALID(CUB.IRID) INVALID
, CUB.DISPLAYNAME DISPLAY_NAME
, CUB.DESCRIPTION DESCRIPTION
FROM
DBA_USERS U
, CWM$MODEL SCH
, CWM$CUBE CUB
WHERE U.USERNAME = SCH.PHYSICALNAME
AND SCH.IRID = CUB.DATAMODEL_IRID
WITH READ ONLY
|
|
|