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;