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;