Oracle | DBMS_SHARDING

Oracle DBMS_SHARDING_DIRECTORY Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose Support utilities for directory-based sharding with functions that can be executed by a shard user.

AUTHID CURRENT_USER

Dependencies

DBMS_DIR_SHARD_LIB

Documented No

First Available 23ai

Pragmas SUPPLEMENTAL_LOG_FILE(default, UNSUPPORTED)

Security Model Owned by GSMADMIN_INTERNAL with EXECUTE granted to the PUBLIC role

Source {ORACLE_HOME}/rdbms/admin/dbmsgwmut.sql
{ORACLE_HOME}/rdbms/admin/prvtgwmut.plb

Subprograms

ADDKEYTOPARTITION	MOVEKEYTOPARTITION	REMOVEKEYCOMMIT
ADDKEYTOPARTITIONCOMMIT	REMOVEKEY	SETASSIGNMENTRULE
FLAGKEYFORSPLIT

ADDKEYTOPARTITION (new 23ai)

Adds a key value to a partition in the directory table dbms_sharding_directory.addKeyToPartition( schema_name IN VARCHAR2, root_table IN VARCHAR2, partition_name IN VARCHAR2, key ...);

TBD

ADDKEYTOPARTITIONCOMMIT (new 23ai)

Adds a key to a partition in the directory table and commits the change dbms_sharding_directory.addKeyToPartition( schema_name IN VARCHAR2, root_table IN VARCHAR2, partition_name IN VARCHAR2, key ...);

TBD

FLAGKEYFORSPLIT (new 23ai)

Flags a key value for subsequent partition split in the directory table dbms_sharding_directory.flagKeyForSplit( schema_name IN VARCHAR2, root_table IN VARCHAR2, key ...);

TBD

MOVEKEYTOPARTITION (new 23ai)

Moves a key value and corresponding data in the whole table family to a different partition dbms_sharding_directory.moveKeyToPartition( schema_name IN VARCHAR2, root_table IN VARCHAR2, partition_name IN VARCHAR2 key ...);

TBD

REMOVEKEY (new 23ai)

Deletes a key value from the directory dbms_sharding_directory.removeKey( schema_name IN VARCHAR2, root_table IN VARCHAR2, key ...);

TBD

REMOVEKEYCOMMIT (new 23ai)

Deletes a key value from the directory and commits the change dbms_sharding_directory.removeKey( schema_name IN VARCHAR2, root_table IN VARCHAR2, key ...);

TBD

SETASSIGNMENTRULE (new 23ai)

Set the assignment rule for directory based sharding dbms_sharding_directory.setAssignmentRule(rule_id IN NUMBER);

TBD