Oracle DBMS_XDB_ADMIN
Version 19c

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
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
First Available 2006
Pragma PRAGMA SUPPLEMENTAL_LOG_DATA(default, UNSUPPORTED_WITH_COMMIT);
Security Model Owned by SYS with EXECUTE granted to the DBA role
Source {ORACLE_HOME}/rdbms/admin/dbmsxdba.sql
Subprograms
 
CREATENONCEKEY
Inserts the randomly generated nonce key into the XDB$NONCEKEY table dbms_xdb_admin.createNonceKey;
exec dbms_xdb_admin.createNonceKey;
 
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;
 
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);
 
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.rebuildHeierarchicalIndex;

Related Topics
Built-in Functions
Built-in Packages
DBMS_XDB
DBMS_XDBREPOS
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx