Schema Creation Examples
The following examples show the steps you would take to create a schema for an Oracle Globally Distributed Database using the system-managed, user-defined, and composite sharding methods.
Schema for System-Managed Sharding
Create the tablespace set, sharded tables, and duplicated tables for an Oracle Globally Distributed Database that uses the system-managed sharding method.
Next you should monitor the DDL processing and verify that the tablespace sets, tables, and chunks were correctly created on all of the shards.
Schema for User-Defined Sharding
Create the schema user, tablespace set, sharded tables, and duplicated tables for an Oracle Globally Distributed Database that uses the user-defined sharding method.
Next you should monitor the DDL processing and verify that the tablespace sets, tables, and chunks were correctly created on all of the shards.
Schema for Composite Sharding
Create the schema user, tablespace set, sharded tables, and duplicated tables for an Oracle Globally Distributed Database that uses the composite sharding method.
Next you should monitor the DDL processing and verify that the tablespace sets, tables, and chunks were correctly created on all of the shards.