Welcome Guest, you are in: <root> • Login

Page History: SH MVIEW$_EXCEPTIONS (table)

Compare Page Revisions

1 0 Current 1 0

« Older Revision - Back to Page History - Current Revision

Page Revision: 2010/06/24 08:00

wikibot ¶

Table

SH.MVIEW$_EXCEPTIONS

Columns ¶

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 ¶

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