1 package drvddlx 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 idxmem in number,
19 storage in varchar2
20 );
21
22 /*----------------------- IndexTransport -----------------------*/
23 /*
24 NAME
25 IndexTransport
26
27 DESCRIPTION
28 meta-data cleanup after transportable tablespace
29 */
30 PROCEDURE IndexTransport(
31 owner in varchar2,
32 index_name in varchar2,
33 table_owner in varchar2,
34 table_name in varchar2,
35 IndexInfoFlags in number
36 );
37
38 /*----------------------- IndexDrop -------------------------*/
39 /*
40 NAME
41 IndexDrop
42
43 DESCRIPTION
44 drop an index
45
46 ARGUMENTS
47 ia index info
48 */
49 PROCEDURE IndexDrop(
50 ia in sys.ODCIIndexInfo,
51 owner in varchar2,
52 index_name in varchar2
53 );
54
55 /*----------------------- IndexRename ---------------------*/
56 /*
57 NAME
58 IndexRename
59
60 DESCRIPTION
61 rename an index
62
63 ARGUMENTS
64 ia index info
65 owner index owner
66 index_name index name
67 new_name new name
68 */
69 PROCEDURE IndexRename(
70 ia in sys.odciindexinfo,
71 owner in varchar2,
72 index_name in varchar2,
73 new_name in varchar2
74 );
75
76 /*----------------------- IndexColRename ---------------------*/
77 /*
78 NAME
79 IndexColRename
80
81 DESCRIPTION
82 rename an index column
83
84 ARGUMENTS
85 ia index info
86 owner index owner
87 index_name index name
88 new_name new name
89 */
90 PROCEDURE IndexColRename(
91 ia in sys.odciindexinfo,
92 owner in varchar2,
93 index_name in varchar2,
94 new_name in varchar2
95 );
96
97 /*----------------------- IndexTruncate ---------------------*/
98 /*
99 NAME
100 IndexTruncate
101
102 DESCRIPTION
103 truncate an index
104
105 ARGUMENTS
106 owner index owner
107 index_name index name
108 */
109 PROCEDURE IndexTruncate(
110 ia in sys.odciindexinfo,
111 owner in varchar2,
112 index_name in varchar2
113 );
114
115 /*----------------------- IndexReplace -------------------------*/
116 /*
117 NAME
118 IndexReplace
119
120 DESCRIPTION
121 rebuild an index, replacing preferences as needed
122
123 ARGUMENTS
124 ia index info
125 idx index record
126 idxmem index memory
127 storage storage pref name
128 */
129 PROCEDURE IndexReplace(
130 ia in sys.ODCIIndexInfo,
131 idx in dr_def.idx_rec,
132 idxmem in number,
133 storage in varchar2
134 );
135
136 /*----------------------- IndexResume -------------------------*/
137 /*
138 NAME
139 IndexResume
140
141 DESCRIPTION
142 resume index creation
143
144 ARGUMENTS
145 ia index info
146 idx index record
147 para parallel degree
148 idxmem index memory
149 */
150 PROCEDURE IndexResume(
151 ia in sys.ODCIIndexInfo,
152 idx in dr_def.idx_rec,
153 idxmem in number
154 );
155
156 /*----------------------- IsBinaryXMLColumn -------------------*/
157 /*
158 NAME
159 IsBinaryXMLColumn
160
161 DESCRIPTION
162 Is this XMLType column stored as binary?
163
164 ARGUMENTS
165 tableSchema schema owning the table
166 tableName table name
167 colName column name
168 */
169 FUNCTION isBinaryXMLColumn(
170 tableSchema IN VARCHAR2,
171 tableName IN VARCHAR2,
172 colName IN VARCHAR2,
173 indexName IN VARCHAR2
174 ) return boolean;
175
176 end drvddlx;