Sharding Key Directory Public View

The view root_table_name$shard_dir_view provides you with the key to partition/chunk/shard mappings for the specified root table.

Table 7-1 root_table_name$SHARD_DIR_VIEW

Name Type NULL Description
KEY columns… varies No Unique sharding key column values
KEY_ID$ RAW(32) No Unique SHA-256 ID assigned to the key
CHUNK_ID$ NUMBER No The chunk ID to which the key is assigned
PARTITION_NAME VARCHAR2(128) No Name of the root table partition the key is assigned to
SHARDSPACE_NAME VARCHAR2(128) No The shardspace name where the chunk belongs to
SPLIT_FLAG$ NUMBER Yes

0: not flagged (default)

1: flagged