Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to use tables from multiple schemas in RPD?

Received Response
61
Views
1
Comments
User_PKUN0
User_PKUN0 Rank 1 - Community Starter
edited Aug 13, 2024 5:11PM in Oracle Analytics Forum

Hi all,

I have 2 schemas A and B in database DB. I need to use table from both schemas in my RPD by connecting to DB. I have created a user U and provided grants to schema A and B. Now without creating synonyms of table from schema A in Schema B or vice versa what can I do so that I can use both schemas. Checking the "Request fully qualified table names" didn't work.

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    You just define the schemas first inside your physical database in the RPD, you then add tables inside the schemas.

    A schema isn't mandatory in the physical layer, but in that case all objects should be owned by the user you use to connect to the DB (and would require synonyms as you mentioned).

    If you define the schemas A and B, you can then have tables of these schemas under each, while using a single connection pool with your user "U". If you use the import metadata wizard it should create the schemas when importing tables/views.