Oracle DBMS_XDB_ADMIN
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
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
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 12cR1
What's New In 12cR2

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-2017 Daniel A. Morgan All Rights Reserved