Data Dictionary of Oracle 11g



Index | Home | Forums

Table Name Description
ALL_DIM_LEVELS Description of dimension levels visible to DBA

Column ID Column name Data type Length Precision NULL Description
1OWNERVARCHAR230(null)NOwner of the dimension
2DIMENSION_NAMEVARCHAR230(null)NName of the dimension
3LEVEL_NAMEVARCHAR230(null)YName of the dimension level (unique within a dimension)
4NUM_COLUMNSNUMBER22(null)YNumber of columns in the level definition
5DETAILOBJ_OWNERVARCHAR230(null)NOwner of the detail object that the keys of this level come from
6DETAILOBJ_NAMEVARCHAR230(null)NName of the table that the keys of this level come from
7SKIP_WHEN_NULLVARCHAR21(null)YIs the level declared with SKIP WHEN NULL clause? (Y/N)

Index | Home | Forums

This page was created by oracleabc.com on Dec 31,2007 18:49:29
General comments and questions regarding this document should be sent by email to info@oracleabc.com or post your comments here