| General Information |
| Purpose |
Provides an interface to manage the XMLIndex on the XML DB repository |
| Source |
{ORACLE_HOME}/rdbms/admin/dbmsxdba.sql |
| Dependencies |
|
| Security Model |
Owned by XDB with execute granted to the DBA role |
| Subprograms |
|
| |
| CLEARREPOSITORYXMLINDEX |
| Unmarks the indexed flags of the XML Index on the repository |
dbms_xdb_admin.clearRepositoryXMLIndex; |
| exec ClearRepositoryXMLIndex; |
| |
| CREATEREPOSITORYXMLINDEX (deprecated in 11.2.0.3) |
| Create an XML Index on the repository |
dbms_xdb_admin.createRepositoryXMLIndex; |
| exec CreateRepositoryXMLIndex; |
| |
| DROPREPOSITORYXMLINDEX (deprecated in 11.2.0.3) |
| Drop an XML Index on the repository |
dbms_xdb_admin.dropRepositoryXMLIndex; |
| exec DropRepositoryXMLIndex; |
| |
MOVEXDB_TABLESPACE (new 11.2.0.3)  |
| 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 (new 11.2.0.3) |
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; |
| |
| XMLINDEXADDPATH (deprecated in 11.2.0.3) |
| Index resources at path 'path' or all resources in the subtree rooted at 'path' |
dbms_xdb_admin.XMLIndexAddPath(path IN VARCHAR2, recurse IN BOOLEAN := TRUE); |
DECLARE
ret BOOLEAN;
BEGIN
ret := dbms_xdb_admin.XMLIndexAddPath('/PurchaseOrder', FALSE);
END;
/ |
| |
| XMLINDEXREMOVEPATH (deprecated in 11.2.0.3) |
Removes resource at path 'path' from the Repository XML Index or removes all resources in the subtree rooted at
'path' from the Repository XML Index |
dbms_xdb_admin.XMLIndexRemovePath(path IN VARCHAR2, recurse IN BOOLEAN := TRUE); |
DECLARE
ret BOOLEAN;
BEGIN
ret := dbms_xdb_admin.XMLIndexRemovePath('/PurchaseOrder', FALSE);
ret := dbms_xdb_admin.XMLIndexRemovePath('/PurchaseOrder/MLib', TRUE);
END; |
