Oracle DBMS_XDB_ADMIN
Version 21c

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

Related Topics
Built-in Functions
Built-in Packages
DBMS_XDBREPOS
DBMS_XDB
DBMS_XDB_CONFIG
DBMS_XDB_CONSTANTS
DBMS_XDB_CONTENT
DBMS_XDB_PRINT
DBMS_XDB_UTIL
DBMS_XDB_VERSION
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