1 package drvddlc authid current_user as
2
3 /*----------------------- IndexCreate -----------------------*/
4 /*
5 NAME
6 IndexCreate
7
8 DESCRIPTION
9 create an index
10
11 ARGUMENTS
12 owner index owner
13 index_name index name
14 table_owner table owner
15 table_name table name
16 column_name text column name
17 langcol language column
18 fmtcol format column name
19 csetcol charset column name
20 configcol configuration column name
21 idxmem index memory
22 datastore datastore pref name
23 filter filter pref name
24 section section group pref name
25 lexer lexer pref name
26 wordlist wordlist pref name
27 stoplist stoplist pref name
28 storage storage pref name
29 indexset index set name
30
31 NOTES
32
33 EXCEPTIONS
34
35 RETURNS
36
37 */
38 PROCEDURE IndexCreate(
39 ia in sys.odciindexinfo,
40 owner in varchar2,
41 index_name in varchar2,
42 table_owner in varchar2,
43 table_name in varchar2,
44 column_name in varchar2,
45 langcol in varchar2,
46 fmtcol in varchar2,
47 csetcol in varchar2,
48 idxmem in number,
49 datastore in varchar2,
50 filter in varchar2,
51 section in varchar2,
52 lexer in varchar2,
53 wordlist in varchar2,
54 stoplist in varchar2,
55 storage in varchar2,
56 indexset in varchar2,
57 configcol in varchar2
58 );
59
60 /*----------------------- IndexRename ---------------------*/
61 /*
62 NAME
63 IndexRename
64
65 DESCRIPTION
66 rename an index
67
68 ARGUMENTS
69 ia index info
70 owner index owner
71 index_name index name
72 new_name new name
73 */
74 PROCEDURE IndexRename(
75 ia in sys.odciindexinfo,
76 owner in varchar2,
77 index_name in varchar2,
78 new_name in varchar2
79 );
80
81 /*----------------------- IndexColRename ---------------------*/
82 /*
83 NAME
84 IndexColRename
85
86 DESCRIPTION
87 rename an index column
88
89 ARGUMENTS
90 ia index info
91 owner index owner
92 index_name index name
93 new_name new name
94 */
95 PROCEDURE IndexColRename(
96 ia in sys.odciindexinfo,
97 owner in varchar2,
98 index_name in varchar2,
99 new_name in varchar2
100 );
101
102 /*----------------------- IndexTruncate ---------------------*/
103 /*
104 NAME
105 IndexTruncate
106
107 DESCRIPTION
108 truncate an index
109
110 ARGUMENTS
111 owner index owner
112 index_name index name
113 */
114 PROCEDURE IndexTruncate(
115 ia in sys.odciindexinfo,
116 owner in varchar2,
117 index_name in varchar2
118 );
119
120 /*----------------------- IndexDrop -------------------------*/
121 /*
122 NAME
123 IndexDrop
124
125 DESCRIPTION
126 drop an index
127
128 ARGUMENTS
129 ia index info
130 */
131 PROCEDURE IndexDrop(
132 ia in sys.ODCIIndexInfo,
133 owner in varchar2,
134 index_name in varchar2
135 );
136
137 /*----------------------- IndexReplace -------------------------*/
138 /*
139 NAME
140 IndexReplace
141
142 DESCRIPTION
143 rebuild an index, replacing preferences as needed
144
145 ARGUMENTS
146 ia index info
147 idx index record
148 idxmem index memory
149 para parallel degree (ignored)
150 idxset index set name
151 lexer lexer pref name
152 wordlist wordlist pref name
153 stoplist stoplist pref name
154 storage storage pref name
155
156 */
157 PROCEDURE IndexReplace(
158 ia in sys.ODCIIndexInfo,
159 idx in dr_def.idx_rec,
160 idxmem in number,
161 para in number,
162 idxset in varchar2,
163 lexer in varchar2,
164 wordlist in varchar2,
165 stoplist in varchar2,
166 storage in varchar2
167 );
168
169 /*----------------------- IndexTransport -----------------------*/
170 /*
171 NAME
172 IndexTransport
173
174 DESCRIPTION
175 transport tablespace support
176
177 ARGUMENTS
178 owner index owner
179 index_name index name
180 index_part index partition name
181 table_owner table owner
182 table_name table name
183 table_part table partition name
184
185 NOTES
186
187 EXCEPTIONS
188
189 RETURNS
190
191 */
192 PROCEDURE IndexTransport(
193 owner in varchar2,
194 index_name in varchar2,
195 index_part in varchar2,
196 table_owner in varchar2,
197 table_name in varchar2,
198 table_part in varchar2,
199 IndexInfoFlags in number,
200 CallProperty in number
201 );
202
203 end drvddlc;