Oracle | DBMS_SHARDING

Oracle DBMS_SHARDING_DIRECTORY Version 23c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

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 23.2

Pragmas PRAGMA SUPPLEMENTAL_LOG_FILE(default, UNSUPPORTED)

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

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

Subprograms

ADDKEYTOPARTITION	FLAGKEYFORSPLIT	REMOVEKEYCOMMIT
ADDKEYTOPARTITIONCOMMIT	REMOVEKEY

ADDKEYTOPARTITION (new 23c)

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 ...); PRAGMA SUPPLEMENTAL_LOG_DATA(addKeyToPartition, UNSUPPORTED);

TBD

ADDKEYTOPARTITIONCOMMIT (new 23c)

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 ...); PRAGMA SUPPLEMENTAL_LOG_DATA(addKeyToPartitionCommit, UNSUPPORTED_WITH_COMMIT);

TBD

FLAGKEYFORSPLIT (new 23c)

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

REMOVEKEY (new 23c)

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

TBD

REMOVEKEYCOMMIT (new 23c)

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

TBD