1. Using Oracle Sharding
  2. Query and DML Execution
  3. Connecting to the Query Coordinator

Connecting to the Query Coordinator

The Oracle Sharding query coordinator, a component of the shard catalog, contains the metadata of the sharded topology and provides query processing support for sharded databases.

To perform multi-shard queries, connect to the multi-shard coordinator using the GDS$CATALOG service on the shard catalog database. 

sqlplus app_schema/app_schema@shardcatvm:1521/GDS\$CATALOG.oradbcloud

For more information about the coordinator, see Query Processing and the Query Coordinator

Parent topic: Query and DML Execution