1 Reply Latest reply on Dec 28, 2019 11:28 AM by Sailaja-Oracle

    CDB Fleet - DB link direction

    RobK

      Hello!

       

      When configuring a CDB Fleed it is strange to me that the DB links are created from the Members pointing to the Lead.

      Could someone give an explanation how the selects executed on the Lead can reach the Members and why the DB links are not created the other way around.

       

      I mean an SQL like this executed on the LEAD:

      SELECT col FROM

      CONTAINERS(common_table);

       

      How does it work when the DB links are pointing the other way around?

       

      Thanks,

      RobK

        • 1. Re: CDB Fleet - DB link direction
          Sailaja-Oracle

           

          Hi,

           

          A CDB fleet provides the database infrastructure for scalability and centralized management of many CDBs.

           

          Designate a fleet member by setting the LEAD_CDB_URI database property to a database link that points to the lead CDB.

          Prerequisites

          You must use a database link with fixed user semantics, which means that the user name and password are in the link definition. The link cannot use connected user semantics, in which case the user name and password are not in the link definition.