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

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