SH.MVIEW$ EXCEPTIONS (table)

From dbscript Online Help
Jump to: navigation, search

wikibot[edit]

Table SH.MVIEW$_EXCEPTIONS

Columns[edit]

Column Data Type Nullable Default Description
OWNER VARCHAR2(30) not null
TABLE_NAME VARCHAR2(30) not null
DIMENSION_NAME VARCHAR2(30) not null
RELATIONSHIP VARCHAR2(11) not null
BAD_ROWID ROWID not null

Check Constraints[edit]

Check Constraint Expression Description
SYS_C005192 "OWNER" IS NOT NULL
SYS_C005193 "TABLE_NAME" IS NOT NULL
SYS_C005194 "DIMENSION_NAME" IS NOT NULL
SYS_C005195 "RELATIONSHIP" IS NOT NULL
SYS_C005196 "BAD_ROWID" IS NOT NULL