Oracle | DBMS_XDB

Oracle DBMS_XDB_ADMIN 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 Provides an interface to manage the XMLIndex on the XML DB repository.

AUTHID CURRENT_USER

Dependencies

ALL_INDEXES	DBMS_STANDARD	UTL_FILE
DBMS_ASSERT	DBMS_XDBUTIL_INT	XDB$H_INDEX
DBMS_LOB	DBMS_XDBZ	XDB$H_LINK
DBMS_OUTPUT	DBMS_XDB_LIB	XDB$RESOURCE
DBMS_PDB_EXEC_SQL	DBMS_XDB_UTIL	XDB$ROOT_INFO

Documented Yes

Exceptions

Error Code	Reason
ORA-31097	`Hierarchical Index not empty`

First Available 2006

Pragma PRAGMA SUPPLEMENTAL_LOG_DATA(default, UNSUPPORTED_WITH_COMMIT);

Security Model Owned by XDB with EXECUTE granted to the DBA role

Source {ORACLE_HOME}/rdbms/admin/dbmsxdba.sql

Subprograms

CREATENONCEKEY	MOVEXDB_TABLESPACE	REBUILDHIERARCHICALINDEX
INSTALLDEFAULTWALLET

CREATENONCEKEY

Inserts the randomly generated nonce key into the XDB$NONCEKEY table dbms_xdb_admin.createNonceKey;

exec dbms_xdb_admin.createNonceKey;

      

      PL/SQL procedure successfully completed.

INSTALLDEFAULTWALLET

Installs a certificate into the default XDB wallet stored in the default XDB wallet directory dbms_xdb_admin.installDefaultWallet;

exec dbms_xdb_admin.installDefaultWallet;

      

      PL/SQL procedure successfully completed.

MOVEXDB_TABLESPACE

Moves xdb to the specified tablespace after waiting for all XDB sessions to exit dbms_xdb_admin.moveXDB_Tablespace( new_tablespace IN VARCHAR2, trace IN BOOLEAN := FALSE);

exec dbms_xdb_admin.moveXDB_Tablespace('XDBTBS');

      Error movexdb_tablespace: ORA-12719: operation 
      requires database is in RESTRICTED mode

      ORA-00942: table or view does not exist

      BEGIN dbms_xdb_admin.moveXDB_Tablespace('XDBTBS'); END;

      *

      ORA-12719: operation requires database is in RESTRICTED mode

REBUILDHIERARCHICALINDEX

Rebuilds the hierarchical Index; Used after imp/exp since we do cannot export data from xdb$h_index as it contains rowids dbms_xdb_admin.rebuildHeierarchicalIndex;

exec dbms_xdb_admin.rebuildHierarchicalIndex;

          
      *

      ORA-31097: Hierarchical Index not empty