197 DBMS_XDB_ADMIN
The DBMS_XDB_ADMIN
package provides an interface to manage the Oracle XML DB repository.
This chapter contains the following topics:
See Also:
Oracle XML DB Developer's Guide for information about Oracle XML DB Repository
197.1 DBMS_XDB_ADMIN Security Model
Owned by XDB
, the DBMS_XDB_ADMIN
package must be created by SYS
or XDB
. The EXECUTE
privilege is granted to SYS
or XDB
or DBA
. Subprograms in this package are executed using the privileges of the current user.
197.2 Summary of DBMS_XDB_ADMIN Subprograms
This table lists the package subprograms in alphabetical order.
Table 197-1 DBMS_XDB_ADM Package Subprograms
Subprogram | Description |
---|---|
Generates a nonce value for use in digest authentication |
|
Installs the default XDB wallet in the default XDB wallet directory |
|
Moves the XDB (user) to the specified tablespace |
|
Rebuilds the hierarchical index after import or export operations |
197.2.1 CREATENONCEKEY Procedure
This procedure generates a nonce value for use in digest authentication.
Syntax
DBMS_XDB_ADMIN.CREATENONCEKEY;
197.2.2 INSTALLDEFAULTWALLET Procedure
This procedure installs the default XDB wallet in the default XDB wallet directory.
The directory name where the XDB wallet is stored is prefixed either by ORACLE_BASE
when it is defined, or ORACLE_HOME
. It is then followed by /admin/
db_name
/xdb_wallet
where db_name is the unique database name.
Syntax
DBMS_XDB_ADMIN.INSTALLDEFAULTWALLET;
Usage Notes
Only SYS
can install or replace the default wallet.
197.2.3 MOVEXDB_TABLESPACE Procedure
This procedure moves the XDB (user) to the specified tablespace.
Syntax
DBMS_XDB_ADMIN.MOVEXDB_TABLESPACE( new_tablespace IN VARCHAR2);
Parameters
Table 197-2 MOVEXDB_TABLESPACE Procedure Parameters
Parameter | Description |
---|---|
|
Name of the tablespace to where the XDB is moved |
Usage Notes
-
This operation waits for all concurrent XDB sessions to exit.
-
If
MOVEXDB_TABLESPACE
fails, the user should restart the database before issuing any further command.Failure to do so will result into unexpected behavior from the database. -
The XDB repository by default resides in the
SYSAUX
tablespace. Using this procedure it can be moved to another tablespace. As a best practice we recommend to create a dedicated tablespace for the XDB repository only and not share it with other objects (such as tables). The tablespace containing the XDB repository should never be set toREAD
ONLY
because this might affect various XML operations being executed.