1 package CTX_ADM as
2
3 /*------------------------------- shutdown ----------------------------------*/
4 /*
5 NAME
6 shutdown
7
8 DESCRIPTION
9 this call is obsolete. It exists simply to avoid invalidating
10 obsolete customer code which may call it.
11 */
12
13 procedure shutdown(
14 name in varchar2 default 'ALL',
15 sdmode in number default NULL
16 );
17
18 /*------------------------- recover ----------------------------*/
19 /*
20 NAME
21 recover
22 DESCRIPTION
23 Recover data dictionary
24 ARGUMENTS
25 */
26 procedure recover;
27 PRAGMA SUPPLEMENTAL_LOG_DATA(recover, AUTO);
28
29 /*------------------------- set_parameter ----------------------------*/
30 /*
31 NAME
32 set_parameter
33
34 DESCRIPTION
35 Set a system parameter
36
37 ARGUMENTS
38 param name
39 param value
40
41 */
42 procedure set_parameter(param_name in varchar2, param_value in varchar2);
43 PRAGMA SUPPLEMENTAL_LOG_DATA(set_parameter, AUTO);
44
45 /*------------------------- test_extproc ----------------------------*/
46 /*
47 NAME
48 test_extproc
49
50 DESCRIPTION
51 test extproc invocation
52
53 NOTES
54 If this procedure succeeds, extproc can be invoked
55
56 */
57 procedure test_extproc;
58
59 /*------------------------- mark_failed ----------------------------*/
60 /*
61 NAME
62 mark_failed
63
64 DESCRIPTION
65 mark the index status from INPROGRESS to FAILURE so that
66 alter index can run.
67
68 NOTES
69 this procedure is not published
70 */
71
72 procedure mark_failed(owner_name in varchar2, index_name in varchar2);
73 PRAGMA SUPPLEMENTAL_LOG_DATA(mark_failed, AUTO);
74
75 /*------------------------ drop_user_objects ---------------------------*/
76 /*
77 NAME
78 drop_user_objects
79
80 DESCRIPTION
81 Drops all of the text objects (preferences, etc.) for the given user. If
82 the user does not exist or there are no objects, no errors are raised.
83
84 NOTES
85 This is called during a database DROP USER operation.
86 */
87 procedure drop_user_objects(user_name in varchar2);
88
89 /*--------------------------- reset_auto_optimize_status -------------------*/
90 /* reset the autoopt_status table */
91 procedure reset_auto_optimize_status;
92
93 /*--------------------------- stop_optimize --------------------------------*/
94 /* stop an optimize for an index / partition */
95 procedure stop_optimize(owner_name in varchar2,
96 index_name in varchar2,
97 partition_name in varchar2 default null);
98
99 end CTX_ADM;