Oracle | DBMS_XDB

Oracle DBMS_XDB_ADMIN Version 21c

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 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;

      *

      ERROR at line 1:

      ORA-12719: operation requires database is in RESTRICTED mode

      ORA-06512: at "XDB.DBMS_XDB_ADMIN", line 1046

      ORA-06512: at "XDB.DBMS_XDB_ADMIN", line 535

      ORA-06512: at "XDB.DBMS_XDB_ADMIN", line 1026

      ORA-06512: at line 1

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;

      BEGIN dbms_xdb_admin.rebuildHierarchicalIndex; END;

      *

      ERROR at line 1:

      ORA-31097: Hierarchical Index not empty

      ORA-06512: at "XDB.DBMS_XDB_ADMIN", line 1050

      ORA-06512: at "XDB.DBMS_XDB_ADMIN", line 1061

      ORA-06512: at line 1