DBA Data[Home] [Help]

PACKAGE: XDB.DBMS_XDB_ADMIN

Source


1 PACKAGE     dbms_xdb_admin AUTHID CURRENT_USER IS
2 --------
3 PRAGMA SUPPLEMENTAL_LOG_DATA(default, UNSUPPORTED_WITH_COMMIT);
4 
5 -- Procedure to create an XML Index on the repository
6 procedure CreateRepositoryXMLIndex;
7 
8 -- Procedure to index resource at path 'path' or all resources in
9 -- the subtree rooted at 'path'.
10 procedure XMLIndexAddPath(path      IN VARCHAR2,
11                           recurse   IN boolean := TRUE);
12 
13 -- Procedure to remove resource at path 'path' from the Repository
14 -- XML Index or to remove all resources in the subtree rooted at
15 -- 'path' from the Repository XML Index.
16 procedure XMLIndexRemovePath(path        IN VARCHAR2,
17                              recurse     IN boolean := TRUE);
18 
19 -- Procedure to drop an XML Index on the repository
20 procedure DropRepositoryXMLIndex;
21 
22 -- Procedure to unmark the indexed flags of the XML Index on the repository
23 procedure ClearRepositoryXMLIndex;
24 
25 ---------------------------------------------
26 -- PROCEDURE - CreateNonceKey
27 --     Insert the randomly generated nonce key into XDB$NONCEKEY table
28 -- NOTE: Should be called by DBA only, thus in this package
29 ---------------------------------------------
30 procedure CreateNonceKey;
31 
32 ---------------------------------------------
33 -- PROCEDURE - movexdb_tablespace
34 --     Moves xdb in the specified tablespace. The move waits for all
35 --     concurrent XDB sessions to exit.
36 -- PARAMETERS - name of the tablespace where xdb is to be moved.
37 --            - trace: if TRUE, use set serveroutput on to display
38 --                     progress status information; default FALSE
39 --
40 ---------------------------------------------
41 PROCEDURE movexdb_tablespace(new_tablespace IN VARCHAR2,
42                              trace IN BOOLEAN := FALSE);
43 
44 ---------------------------------------------
45 -- PROCEDURE - RebuildHierarchicalIndex
46 --     Rebuilds the hierarchical Index; Used after
47 --     imp/exp since we do cannot export data from
48 --     xdb$h_index table since it contains rowids
49 -- PARAMETERS -
50 --
51 ---------------------------------------------
52 PROCEDURE RebuildHierarchicalIndex;
53 
54 -------------------------------------------------------------------------------
55 -- FUNCTION - installDefaultWallet
56 --    Install a certificate in the default xdb the wallet stored in
57 --    the default XDB wallet directory.
58 --    Directory name where the XDB wallet is stored is prefixed either
59 --    by ORACLE_BASE when it is defined else ORACLE_HOME.
60 --    Then it is followed by "/admin/<db_name>/xdb_wallet" where <db_name>
61 --    is the unique database name.
62 --    This function can be called if the xdb self-sign on and auto-login wallet
63 --    installed in the default location or if the existing one expired.
64 --
65 -- PARAMETERS
66 --    None
67 --
68 -- NOTE
69 --    - Only sys can intall/replace the default wallet
70 --    - This function replaces the wallet if one exists in the default
71 --      xdb wallet location.
72 --    - Two files are expected to be created in the default location:
73 --        - cwallet.sso
74 --        - ewallet.p12
75 -------------------------------------------------------------------------------
76 procedure installDefaultWallet;
77 
78 end dbms_xdb_admin;