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.
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 ...
What happens to materialized view log when materialize view is …
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?
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 …
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.
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 …
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, …