DBA Data[Home] [Help]

VIEW: SYS.CDB_MVIEW_DETAIL_SUBPARTITION

Source

View Text - Preformatted

SELECT "OWNER","MVIEW_NAME","DETAILOBJ_OWNER","DETAILOBJ_NAME","DETAIL_PARTITION_NAME","DETAIL_SUBPARTITION_NAME","DETAIL_SUBPARTITION_POSITION","FRESHNESS","CON_ID" FROM CONTAINERS("SYS"."DBA_MVIEW_DETAIL_SUBPARTITION")
View Text - HTML Formatted

SELECT "OWNER"
, "MVIEW_NAME"
, "DETAILOBJ_OWNER"
, "DETAILOBJ_NAME"
, "DETAIL_PARTITION_NAME"
, "DETAIL_SUBPARTITION_NAME"
, "DETAIL_SUBPARTITION_POSITION"
, "FRESHNESS"
, "CON_ID"
FROM CONTAINERS("SYS"."DBA_MVIEW_DETAIL_SUBPARTITION")