Hi,
Can you please tell me if we can create a join between two tables or two views that are part of two different schemas in a database object.If it is possible then how to join them.?
Appreciate your response
Thanks,
Yaseen
Using fully qualified names you shouldn't have an issue ... providing your one connection pool can 'see' both schemas.
The issue of performance will arise if the schemas are in different databases - a cross database join will be slow.
To add the two tables to the physical diagram to build the join - treat them as if they were in the same schema -- there's no difference in the HOW of it all - except for the configuration of using fully qualified names.
Thanks for the response Thomas...
Let us know if you hit a snag ...
Hello, Starting with the OAC September 2026 update, you’ll notice some changes to the Workbook authoring experience. The Data, Visualize, and Present tabs will no longer be displayed at the top of the Workbook. Here’s how you can navigate between these experiences going forward. Presenting and configuring a presentation…
Learn how Fusion Data Intelligence supports customization and extensibility across content, data, semantic modeling, and security. This session explains why customers extend FDI, how the FDI architecture enables governed customization, and how to choose among OAC self-service, Data Augmentation, Semantic Model Extensions,…
We have Iceberg tables stored in OCI Object Storage with the standard structure: table/ ├── data/ └── metadata/ I found the AIDP sample notebook for working with Iceberg through Spark using a Hadoop Catalog, which is an example to support reading and writing Iceberg tables from notebooks. [github.com] However, I have not…
The difference column is a calculation, and I would like to average that row.
Hi Everyone, We're running into a challenge in OAS 2026 with Data Visualization (DV) workbooks embedded in Classic Answers dashboards. Our requirement is to: Allow the embedded DV workbook to respond to Answers dashboard prompts. Prevent users from accessing the "Drill to Attribute/Hierarchy..." option from the right-click…
