[Home] [Help] [Dependency Information]
Object Name: | MD$DIM |
---|---|
Object Type: | TABLE |
Owner: | MDSYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MD24A | NORMAL | UNIQUE | SYSTEM |
OWNER
MDTNAME CNAME DIM# |
Table | |
Foreign Table | Foreign Key Column | MD$DIM | MD$COL |
MD$DIM
OWNER
MD$DIM MDTNAME MD$DIM CNAME |
MD$DIM | MD$TAB |
MD$DIM
OWNER
MD$DIM MDTNAME |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (30) | ||
MDTNAME | VARCHAR2 | (30) | ||
CNAME | VARCHAR2 | (30) | Yes | |
DIM# | NUMBER | Yes | ||
NAME | VARCHAR2 | (19) | Yes | |
LB | NUMBER | Yes | ||
UB | NUMBER | Yes | ||
SCALE | NUMBER | Yes | ||
LEV | NUMBER | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, MDTNAME
, CNAME
, DIM#
, NAME
, LB
, UB
, SCALE
, LEV
FROM MDSYS.MD$DIM;
MDSYS.MD$DIM does not reference any database object
MDSYS.MD$DIM is referenced by following:
|
|
|