SQL query to extract UDT table — Cloud Customer Connect
Apr 13, 2023 · Hello, We are trying to create a data model in which we can pull all the data of the UDT into a report. The sql I have been using is the following.
What happens to materialized view log when materialize view is …
May 24, 2012 · What happens to materialized view log when materialize view is on a database that was dropped? May 24, 2012 11:40AM edited May 26, 2012 7:54PM 3 comments Answered
Query for materialized view space and date created?
May 4, 2015 · Is there anyway to query for when a materialized view was created and how much data is in it?
ORA-04063: package body "SYS.DBMS_SNAPSHOT_UTL" has errors
Apr 16, 2013 · Dear Team, while access the users below are the error showing in the alert log.User not able to continue the work and i can't able to create new materialize views ...
Need help to pull Organization ID per Hierarchy Level — Oracle
Dec 3, 2024 · We are looking to pull the Organization ID for each hierarchical level, specifically for Level 1, Level 2, and Level 3.
FCCS: how to add The Non-Indexed Attribute to a dense dimension
Jan 23, 2023 · A non-indexed attribute dimension is primarily a metadata construct used for filtering, although it can be materialized in the database during cube refresh in various ways, …
Oracle Transactional Business Intelligence
Welcome to the Oracle Transactional Business Intelligence Community Forum! Whether you're a seasoned user or just starting your journey with OTBI, the solution for transactional reporting …