1 package drvddlr authid current_user as
2
3 /*----------------------- IndexCreate -----------------------*/
4 /*
5 NAME
6 IndexCreate
7
8 DESCRIPTION
9 create an index
10 */
11 PROCEDURE IndexCreate(
12 ia in sys.odciindexinfo,
13 owner in varchar2,
14 index_name in varchar2,
15 table_owner in varchar2,
16 table_name in varchar2,
17 column_name in varchar2,
18 populate in boolean,
19 langcol in varchar2,
20 fmtcol in varchar2,
21 csetcol in varchar2,
22 idxmem in number,
23 datastore in varchar2,
24 filter in varchar2,
25 section in varchar2,
26 lexer in varchar2,
27 wordlist in varchar2,
28 stoplist in varchar2,
29 storage in varchar2,
30 classifier in varchar2,
31 configcol in varchar2
32 );
33
34 /*----------------------- IndexRename ---------------------*/
35 /*
36 NAME
37 IndexRename
38
39 DESCRIPTION
40 rename an index
41
42 ARGUMENTS
43 ia index info
44 owner index owner
45 index_name index name
46 new_name new name
47 */
48 PROCEDURE IndexRename(
49 ia in sys.odciindexinfo,
50 owner in varchar2,
51 index_name in varchar2,
52 new_name in varchar2
53 );
54
55 /*----------------------- IndexColRename ---------------------*/
56 /*
57 NAME
58 IndexColRename
59
60 DESCRIPTION
61 rename an index column
62
63 ARGUMENTS
64 ia index info
65 owner index owner
66 index_name index name
67 new_name new name
68 */
69 PROCEDURE IndexColRename(
70 ia in sys.odciindexinfo,
71 owner in varchar2,
72 index_name in varchar2,
73 new_name in varchar2
74 );
75
76 /*----------------------- IndexTruncate ---------------------*/
77 /*
78 NAME
79 IndexTruncate
80
81 DESCRIPTION
82 truncate an index
83
84 ARGUMENTS
85 owner index owner
86 index_name index name
87 */
88 PROCEDURE IndexTruncate(
89 ia in sys.odciindexinfo,
90 owner in varchar2,
91 index_name in varchar2
92 );
93
94 /*----------------------- IndexDrop -------------------------*/
95 /*
96 NAME
97 IndexDrop
98
99 DESCRIPTION
100 drop an index
101
102 ARGUMENTS
103 ia index info
104 */
105 PROCEDURE IndexDrop(
106 ia in sys.ODCIIndexInfo,
107 owner in varchar2,
108 index_name in varchar2
109 );
110
111 /*----------------------- IndexReplace -------------------------*/
112 /*
113 NAME
114 IndexReplace
115
116 DESCRIPTION
117 rebuild an index, replacing preferences as needed
118
119 ARGUMENTS
120 ia index info
121 idx index record
122 idxmem index memory
123 para parallel degree
124 langcol language column
125 fmtcol format column name
126 csetcol charset column name
127 configcol charset column name
128 datastore datastore pref name
129 filter filter pref name
130 section section group pref name
131 lexer lexer pref name
132 wordlist wordlist pref name
133 stoplist stoplist pref name
134 storage storage pref name
135 classifier classifier pref name
136 */
137 PROCEDURE IndexReplace(
138 ia in sys.ODCIIndexInfo,
139 idx in dr_def.idx_rec,
140 idxmem in number,
141 langcol in varchar2,
142 fmtcol in varchar2,
143 csetcol in varchar2,
144 datastore in varchar2,
145 filter in varchar2,
146 section in varchar2,
147 lexer in varchar2,
148 wordlist in varchar2,
149 stoplist in varchar2,
150 storage in varchar2,
151 classifier in varchar2,
152 configcol in varchar2
153 );
154
155 /*----------------------- IndexResume -------------------------*/
156 /*
157 NAME
158 IndexResume
159
160 DESCRIPTION
161 resume index creation
162
163 ARGUMENTS
164 ia index info
165 idx index record
166 idxmem index memory
167 */
168 PROCEDURE IndexResume(
169 ia in sys.ODCIIndexInfo,
170 idx in dr_def.idx_rec,
171 idxmem in number
172 );
173
174
175 /*----------------------- IndexOptimize -------------------------*/
176 /*
177 NAME
178 IndexOptimize
179
180 DESCRIPTION
181 optimize the index
182
183 ARGUMENTS
184 idx index record
185 index_id index id
186 operation FAST, FULL, or TOKEN
187 maxtime maxtime for gc
188 token text token string
189 */
190 PROCEDURE IndexOptimize(
191 idx in dr_def.idx_rec,
192 operation in varchar2,
193 maxtime in number,
194 token in varchar2
195 );
196
197 /*----------------------- IndexSync -------------------------*/
198 /*
199 NAME
200 IndexSync
201
202 DESCRIPTION
203 sync the index
204
205 ARGUMENTS
206 idx index record
207 idxmem index memory
208 */
209 PROCEDURE IndexSync(
210 idx in dr_def.idx_rec,
211 idxmem in number
212 );
213
214 /*----------------------- IndexTransport -----------------------*/
215 /*
216 NAME
217 IndexTransport
218
219 DESCRIPTION
220 transport tablespace support
221
222 ARGUMENTS
223 owner index owner
224 index_name index name
225 index_part index partition name
226 table_owner table owner
227 table_name table name
228 table_part table partition name
229
230 NOTES
231
232 EXCEPTIONS
233
234 RETURNS
235
236 */
237 PROCEDURE IndexTransport(
238 index_owner in varchar2,
239 index_name in varchar2,
240 table_owner in varchar2,
241 table_name in varchar2,
242 IndexInfoFlags in number
243 );
244
245 end drvddlr;