3.106 ALL_ATTRIBUTE_DIM_TABLES
ALL_ATTRIBUTE_DIM_TABLES
describes the tables used by the attribute dimensions accessible to the current user.
Related Views
-
DBA_ATTRIBUTE_DIM_TABLES
describes the tables used by all attribute dimensions in the database. -
USER_ATTRIBUTE_DIM_TABLES
describes the tables used by the attribute dimensions owned by the current user. This view does not display theOWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of table used by the attribute dimension |
|
|
|
Name of the attribute dimension |
|
|
|
Owner of the table or view used by the attribute dimension |
|
|
|
Name of the table or view used by the attribute dimension |
|
|
|
Alias specified for the table or view; if not specified, the name of the table or view |
IS_REMOTE Foot 1 |
|
|
Indicates whether the source is a remote table. The values are:
|
|
|
|
Order of the table in the list of tables in the |
|
|
|
The ID of the container where the data originates. Possible values include:
|
Footnote 1 This column is available starting with Oracle Database 21c.
See Also: