ALL_ATTRIBUTE_DIM_ATTRS_AE

ALL_ATTRIBUTE_DIM_ATTRS_AE describes the attributes of the attribute dimensions (across all editions) accessible to the current user.

Column Datatype NULL Description
OWNER VARCHAR2(128) NOT NULL Owner of the attribute dimension
DIMENSION_NAME VARCHAR2(128) NOT NULL Name of the attribute dimension
ATTRIBUTE_NAME VARCHAR2(128)   Name of the attribute dimension attribute
TABLE_ALIAS VARCHAR2(128)   Alias of the table or view in the USING clause to which the column belongs
COLUMN_NAME VARCHAR2(128) NOT NULL Name of the column in the table or view on which the attribute is defined
ORDER_NUM NUMBER NOT NULL Order of the attribute in the list of attribute dimension attributes
ORIGIN_CON_ID NUMBER  

The ID of the container where the data originates. Possible values include:

  • 0: This value is used for rows in non-CDBs. This value is not used for CDBs.

  • n: This value is used for rows containing data that originate in the container with container ID n (n = 1 if the row originates in root).

EDITION_NAME VARCHAR2(128)   Name of the application edition where the attribute dimension is defined

See Also: