DBA Data[Home] [Help]

VIEW: OLAPSYS.ALL$OLAP2UFACT_TABLE_GID

Source

View Text - Preformatted

select
  owner,
  cube_name,
  dimension_owner,
  dimension_name,
  hierarchy_name,
  dim_hier_combo_id,
  fact_table_owner,
  fact_table_name,
  column_name
from all$olap2_fact_table_gid
with read only
View Text - HTML Formatted

SELECT OWNER
, CUBE_NAME
, DIMENSION_OWNER
, DIMENSION_NAME
, HIERARCHY_NAME
, DIM_HIER_COMBO_ID
, FACT_TABLE_OWNER
, FACT_TABLE_NAME
, COLUMN_NAME FROM ALL$OLAP2_FACT_TABLE_GID WITH READ ONLY