Skip Headers
Oracle® Database PL/SQL Packages and Types Reference
11g Release 2 (11.2)

Part Number E25788-04
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub
ARPLS214

164 DBMS_XDB_ADMIN

The DBMS_XDB_ADMIN package provides an interface to manage the Oracle XML DB repository.

See Also:

Oracle XML DB Developer's Guide for information about the Oracle XML DB Repository

This chapter contains the following topics:

ARPLS73487

Using DBMS_XDB_ADMIN

ARPLS73489

Deprecated Subprograms

Note:

Oracle recommends that you do not use deprecated procedures in new applications. Support for deprecated features is for backward compatibility only and may be terminated in future releases.

The following subprograms are deprecated with Oracle Database 11g:

ARPLS73490

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.

ARPLS69306

Summary of DBMS_XDB_ADMIN Subprograms

This table lists the package subprograms in alphabetical order.

ARPLS69307Table 164-1 DBMS_XDB_ADM Package Subprograms

Subprogram Description

CREATEREPOSITORYXMLINDEX Procedure

[Deprecated] Creates an XMLIndex on the XML DB repository

DROPREPOSITORYXMLINDEX Procedure

[Deprecated] Drops the XMLIndex on the XML DB repository

MOVEXDB_TABLESPACE Procedure

Moves the XDB (user) to the specified tablespace

REBUILDHIERARCHICALINDEX Procedure

Rebuilds the hierarchical index after import or export operations

XMLINDEXADDPATH Procedure

[Deprecated] Takes a path in XML DB repository as an input and index all the resources under this given path

XMLINDEXREMOVEPATH Procedure

[Deprecated] Removes the index for the given path


ARPLS69308

CREATEREPOSITORYXMLINDEX Procedure

Note:

This procedure is deprecated in Release 11g.

This procedure creates an XMLIndex on the XML DB repository.

Syntax

DBMS_XDB_ADMIN.CREATEREPOSITORYXMLINDEX; 
ARPLS69309

DROPREPOSITORYXMLINDEX Procedure

Note:

This procedure is deprecated in Release 11g.

This procedure drops the XMLIndex on the XML DB repository.

Syntax

DBMS_XDB_ADMIN.DROPREPOSITORYXMLINDEX; 
ARPLS73484

MOVEXDB_TABLESPACE Procedure

This procedure moves the XDB (user) to the specified tablespace.

Syntax

DBMS_XDB.MOVEXDB_TABLESPACE(
   new_tablespace   IN  VARCHAR2);

Parameters

ARPLS73485Table 164-2 MOVEXDB_TABLESPACE Procedure Parameters

Parameter Description

new_tablespace

Name of the tablespace to where the XDB is moved


Usage Notes

ARPLS73486

REBUILDHIERARCHICALINDEX Procedure

This procedure rebuilds the hierarchical index after import or export operations. This is necessary because data cannot be exported from index tables.

Syntax

DBMS_XDB.REBUILDHIERARCHICALINDEX;
ARPLS69310

XMLINDEXADDPATH Procedure

Note:

This procedure is deprecated in Release 11g.

This procedure adds to the repository xmlindex the resource identified by path (when recurse is FALSE) or adds to the repository xmlindex the sub-tree of resources rooted at path (when recurse is TRUE). The default value for recurse is TRUE.

Syntax

DBMS_XDB_ADMIN.XMLINDEXADDPATH(
   path         IN  VARCHAR2, 
   recurse      IN  BOOLEAN);

Parameters

ARPLS69311Table 164-3 XMLINDEXADDPATH Procedure Parameters

Parameter Description

path

Path to a resource

recurse

TRUE or FALSE


ARPLS69312

XMLINDEXREMOVEPATH Procedure

Note:

This procedure is deprecated in Release 11g.

This procedure removes from the repository xmlindex the resource identified by path (when recurse is FALSE) or removes from the repository xmlindex the sub-tree of resources rooted at path (when recurse is TRUE). The default value for recurse is TRUE.

Syntax

DBMS_XDB_ADMIN.XMLINDEXREMOVEPATH(
   path              IN  VARCHAR2, 
   isrecursive       IN  BOOLEAN);

Parameters

ARPLS69313Table 164-4 XMLINDEXREMOVEPATH Procedure Parameters

Parameter Description

path

Path to a resource

recurse

TRUE or FALSE


Reader Comment

   

Comments, corrections, and suggestions are forwarded to authors every week. By submitting, you confirm you agree to the terms and conditions. Use the OTN forums for product questions. For support or consulting, file a service request through My Oracle Support.

Hide Navigation

Quick Lookup

Database Library · Master Index · Master Glossary · Book List · Data Dictionary · SQL Keywords · Initialization Parameters · Advanced Search · Error Messages

Main Categories

This Page

This Document

New and changed documents:
RSS Feed HTML RSS Feed PDF