DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.DBA_MVIEW_DETAIL_SUBPARTITION

Object Details
Object Name: DBA_MVIEW_DETAIL_SUBPARTITION
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Freshness information of all PCT materialized views in the database

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (128) Yes Owner of the materialized view
MVIEW_NAME VARCHAR2 (128) Yes Name of the materialized view
DETAILOBJ_OWNER VARCHAR2 (128) Yes
DETAILOBJ_NAME VARCHAR2 (128) Yes Name of the detail object
DETAIL_PARTITION_NAME VARCHAR2 (128)
Name of the detail object partition
DETAIL_SUBPARTITION_NAME VARCHAR2 (128)
Name of the detail object subpartition
DETAIL_SUBPARTITION_POSITION NUMBER

Position of the detail object subpartition
FRESHNESS CHAR (5)
Freshness of the detail object partition
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OWNER
,      MVIEW_NAME
,      DETAILOBJ_OWNER
,      DETAILOBJ_NAME
,      DETAIL_PARTITION_NAME
,      DETAIL_SUBPARTITION_NAME
,      DETAIL_SUBPARTITION_POSITION
,      FRESHNESS
FROM SYS.DBA_MVIEW_DETAIL_SUBPARTITION;

Dependencies

[top of page]

SYS.DBA_MVIEW_DETAIL_SUBPARTITION references the following:

SchemaSYS
TableOBJ$
TableSUM$
TableSUMDELTA$
TableSUMDETAIL$
TableTABCOMPART$
TableTABSUBPART$
ViewTABSUBPARTV$
TableUSER$
SYS.DBA_MVIEW_DETAIL_SUBPARTITION is referenced by following:

SchemaPUBLIC
SynonymDBA_MVIEW_DETAIL_SUBPARTITION
SchemaSYS
ViewALL_MVIEW_DETAIL_SUBPARTITION
ViewUSER_MVIEW_DETAIL_SUBPARTITION