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 is now availble. If you haven't you downloaded already: Why?

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