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.
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 ...
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, typically as a …
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?
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.
How to extract BPM approval flows? — Cloud Customer Connect
Sep 22, 2025 · A customer decided to return to FSM after switching to BPM on Oracle's recommendation, because BPM supposedly offered more options for better management of approval …
What happens to materialized view log when materialize view is on a ...
May 24, 2012 · Oracle version 10.2.0.4.What happens to materialized view log when materialize view is on a database that was dropped?
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 in …