[Home] [Help]
PACKAGE: CTXSYS.DRIIXS
Source
1 package driixs as
2
3 /*-------------------- create_index_set ---------------------------*/
4
5 PROCEDURE create_index_set(
6 set_name in varchar2,
7 preference_implicit_commit in boolean
8 );
9
10 /*------------------------------ add_index -------------------------*/
11
12 PROCEDURE add_index(
13 set_name in varchar2,
14 column_list in varchar2,
15 storage_clause in varchar2 default null,
16 preference_implicit_commit in boolean
17 );
18
19 /*-------------------- remove_index ---------------------------*/
20
21 PROCEDURE remove_index(
22 set_name in varchar2,
23 column_list in varchar2,
24 preference_implicit_commit in boolean
25 );
26
27 /*-------------------- drop_index_set ---------------------------*/
28
29 PROCEDURE drop_index_set(
30 set_name in varchar2
31 );
32
33 /*---------------------- drop_user_index_sets ----------------------*/
34 PROCEDURE drop_user_index_sets(
35 user_name in varchar2 := null
36 );
37
38 /*------------------------ copy_index_set ------------------------------*/
39
40 function copy_index_set(
41 p_idx_id in number,
42 p_indexset in varchar2,
43 p_rcount out number
44 )
45 return dr_def.pref_rec;
46
47 /*----------------------- GetIndexIndexSet --- -------------------------*/
48 /* get index set from already-existing index */
49
50 PROCEDURE GetIndexIndexSet(
51 p_idx_id in number,
52 o_ixx in out nocopy dr_def.ixx_tab
53 );
54
55 /*----------------------- GetIndexIXSColumns -----------------------------*/
56 /* get index set columns from already-existing index */
57
58 PROCEDURE GetIndexIXSColumns(
59 p_idx_id in number,
60 o_cols in out nocopy dr_def.ixc_tab
61 );
62
63 end driixs;