Difference between revisions of "SH.MVIEW$ EXCEPTIONS (table)"

From dbscript Online Help
Jump to: navigation, search
 
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
+
|- valign="top"
 
| '''Table
 
| '''Table
 
| SH.MVIEW$_EXCEPTIONS
 
| SH.MVIEW$_EXCEPTIONS
|-
 
 
|}
 
|}
 
  
 
=== Columns ===
 
=== Columns ===
Line 17: Line 15:
 
| '''Default
 
| '''Default
 
| '''Description
 
| '''Description
+
 
|-
+
|- valign="top"
 
| OWNER
 
| OWNER
 
| VARCHAR2(30)
 
| VARCHAR2(30)
Line 24: Line 22:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| TABLE_NAME
 
| TABLE_NAME
 
| VARCHAR2(30)
 
| VARCHAR2(30)
Line 30: Line 28:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| DIMENSION_NAME
 
| DIMENSION_NAME
 
| VARCHAR2(30)
 
| VARCHAR2(30)
Line 36: Line 34:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| RELATIONSHIP
 
| RELATIONSHIP
 
| VARCHAR2(11)
 
| VARCHAR2(11)
Line 42: Line 40:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| BAD_ROWID
 
| BAD_ROWID
 
| ROWID
 
| ROWID
Line 56: Line 54:
 
| '''Expression
 
| '''Expression
 
| '''Description
 
| '''Description
+
 
|-
+
|- valign="top"
 
| SYS_C005192
 
| SYS_C005192
 
| "OWNER" IS NOT NULL
 
| "OWNER" IS NOT NULL
 
|  
 
|  
|-
+
|- valign="top"
 
| SYS_C005193
 
| SYS_C005193
 
| "TABLE_NAME" IS NOT NULL
 
| "TABLE_NAME" IS NOT NULL
 
|  
 
|  
|-
+
|- valign="top"
 
| SYS_C005194
 
| SYS_C005194
 
| "DIMENSION_NAME" IS NOT NULL
 
| "DIMENSION_NAME" IS NOT NULL
 
|  
 
|  
|-
+
|- valign="top"
 
| SYS_C005195
 
| SYS_C005195
 
| "RELATIONSHIP" IS NOT NULL
 
| "RELATIONSHIP" IS NOT NULL
 
|  
 
|  
|-
+
|- valign="top"
 
| SYS_C005196
 
| SYS_C005196
 
| "BAD_ROWID" IS NOT NULL
 
| "BAD_ROWID" IS NOT NULL
 
|  
 
|  
 
|}
 
|}

Latest revision as of 06:16, 24 June 2010

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