#shard database

Check error on a Shard during execution of DDL commands with recovery

Checking the error on a Shard during DDL command execution with recovery

Case 1: In this case, user attempt to create tablespace on Shard database but one location is not having write permission on shards.

1. Connect with the shard user SQL> connect example_user/ password1 Connected

2. Try to create a tablespace on shard Database it will apply on all shard (local or remote database) SQL> create…

Sharding Database in Oracle

Sharding Database in Oracle

Sharding is a data tier architecture in which data is horizontally partitioned across independent databases. Oracle Sharding is implemented based on the Oracle Database partitioning feature.

SHARDED DATABASE: Database is host independently with all resources like CPU, disk, memory as standalone server. This database is called shared. All together make a single logical…