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


VIEW: MDSYS.DBA_MD_TABLES

Object Details
Object Name: DBA_MD_TABLES
Object Type: VIEW
Owner: MDSYS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (30) Yes
MD_TABLE_NAME VARCHAR2 (30) Yes
CLASS VARCHAR2 (15)
PTAB_SEQ VARCHAR2 (9)
HIGH_WATER_MARK NUMBER

OFFLINE_PATH VARCHAR2 (255)
COUNT_MODE VARCHAR2 (8)
Query Text

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


SELECT OWNER
,      MD_TABLE_NAME
,      CLASS
,      PTAB_SEQ
,      HIGH_WATER_MARK
,      OFFLINE_PATH
,      COUNT_MODE
FROM MDSYS.DBA_MD_TABLES;

Dependencies

[top of page]

MDSYS.DBA_MD_TABLES references the following:

SchemaMDSYS
TableMD$TAB
MDSYS.DBA_MD_TABLES is referenced by following:

SchemaPUBLIC
SynonymDBA_MD_TABLES