Discover Top Posts Tagged with #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…

View On WordPress

#config #example error #recover shard #Shard database #show ddl #tablespace already exists

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…

View On WordPress

#CREATE #definitions #Shard database #shared table #table family #terms duplicate table #Understand sharding

#shard database

Trending Tags

Recently Viewed Tags

#shard database