ALL_ATTRIBUTE_DIM_TABLES

ALL_ATTRIBUTE_DIM_TABLES describes the tables used by the attribute dimensions accessible to the current user.

Column Datatype NULL Description
OWNER VARCHAR2(128) NOT NULL Owner of table used by the attribute dimension
DIMENSION_NAME VARCHAR2(128) NOT NULL Name of the attribute dimension
TABLE_OWNER VARCHAR2(128) NOT NULL Owner of the table or view used by the attribute dimension
TABLE_NAME VARCHAR2(128) NOT NULL Name of the table or view used by the attribute dimension
TABLE_ALIAS VARCHAR2(128)   Alias specified for the table or view; if not specified, the name of the table or view
IS_REMOTE VARCHAR2(1)  

Indicates whether the source is a remote table. The values are:

  • Y for a remote table
  • N for a local table
ORDER_NUM NUMBER NOT NULL Order of the table in the list of tables in the USING clause
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).

See Also: