[Home] [Help]
PACKAGE: CTXSYS.DRVXTAB
Source
1 package drvxtab authid current_user as
2
3 DEFAULT_SEPARATOR constant varchar2(1) := '$';
4 TMP1_SEPARATOR constant varchar2(1) := 'M';
5 TMP2_SEPARATOR constant varchar2(1) := 'N';
6
7 PROCEDURE part_events_off;
8 PROCEDURE part_events_on;
9
10 /* ====================================================================== */
11 /* ====================================================================== */
12 /* CONTEXT */
13 /* ====================================================================== */
14 /* ====================================================================== */
15
16 /*------------------------- create_a_table --------------------------------*/
17 PROCEDURE create_a_table(
18 idx_owner in varchar2,
19 idx_name in varchar2,
20 idxid in number
21 );
22
23 /*------------------------- create_f_table --------------------------------*/
24 PROCEDURE create_f_table(
25 idx_owner in varchar2,
26 idx_name in varchar2,
27 idxid in number
28 );
29
30 /*-------------------------- create_s_table ------------------------------*/
31 PROCEDURE create_s_table(
32 idx_owner in varchar2,
33 idx_name in varchar2,
34 idxid in number,
35 part_id in number default null,
36 sep in varchar2,
37 part in boolean default FALSE,
38 shadow in boolean default FALSE
39 );
40
41 /*---------------------- part_create_s_tables -----------------------------*/
42 PROCEDURE part_create_s_tables(
43 idx in dr_def.idx_rec
44 );
45
46 /*----------------------- create_index_tables -----------------------------*/
47
48 PROCEDURE create_index_tables(
49 idx_owner in varchar2,
50 idx_name in varchar2,
51 idxid in number,
52 part_id in number default null,
53 temp in boolean default FALSE,
54 part in boolean default FALSE,
55 shadow in boolean default FALSE
56 );
57
58 /*--------------------------- create_g_table ---------------------------*/
59 procedure create_g_table(
60 idx dr_def.idx_rec,
61 part_id in number default 0
62 );
63
64 /*--------------------------- drop_g_table --------------------------------*/
65 procedure drop_g_table(
66 idx dr_def.idx_rec,
67 part_id in number default 0
68 );
69
70 /*--------------------------- add_offsets_column --------------------------*/
71 procedure add_offsets_column(
72 idx dr_def.idx_rec
73 );
74
75 -- 8323978: Removed create_index_triggers
76
77 /*----------------------- create_index_indexes ---------------------------*/
78
79 PROCEDURE create_index_indexes(
80 idx_owner in varchar2,
81 idx_name in varchar2,
82 idxid in number,
83 part_id in number default null,
84 temp in boolean default FALSE,
85 part in boolean default FALSE,
86 status in varchar2 default null
87 );
88
89 /*----------------------- drop_index_tables ---------------------------*/
90
91 PROCEDURE drop_index_tables(
92 idx_owner in varchar2,
93 idx_name in varchar2,
94 idxid in number,
95 has_p in boolean default null,
96 part_id in number default null,
97 temp in boolean default FALSE,
98 isAlter in boolean default FALSE
99 );
100
101 /*----------------------- drop_FA_tables -------------------------------*/
102
103 PROCEDURE drop_FA_tables(
104 idx_owner in varchar2,
105 idx_name in varchar2,
106 idxid in number
107 );
108
109 /*----------------------- trunc_index_tables ---------------------------*/
110
111 PROCEDURE trunc_index_tables(
112 idx_owner in varchar2,
113 idx_name in varchar2,
114 idxid in number,
115 part_id in number default null
116 );
117
118 /*----------------------- rename_index_tables ---------------------------*/
119
120 PROCEDURE rename_index_tables(
121 idx_owner in varchar2,
122 idx_name in varchar2,
123 idxid in number,
124 new_name in varchar2,
125 has_idx in boolean,
126 part_id in number default null
127 );
128
129 /*----------------------- exchange_index_tables --------------------------*/
130
131 PROCEDURE exchange_index_tables(
132 idxp_owner in varchar2,
133 idxp_name in varchar2,
134 idxp_id in number,
135 idxp_pid in number,
136 idxn_owner in varchar2,
137 idxn_name in varchar2,
138 idxn_id in number
139 );
140
141 /*-------------------------- get_create_sql -------------------------------*/
142
143 FUNCTION get_create_sql(
144 idx_owner in varchar2,
145 idx_name in varchar2,
146 idxid in number,
147 part_id in number default null,
148 which in varchar2,
149 sto in out nocopy dr_def.vc500_tab,
150 sep in varchar2 default DEFAULT_SEPARATOR,
151 x_part in boolean default FALSE,
152 char_semantics in varchar2 default 'BYTE'
153 ) RETURN VARCHAR2;
154
155 /*-------------------------- get_object_name ------------------------------*/
156
157 FUNCTION get_constraint_name(
158 idx_owner in varchar2,
159 idx_name in varchar2,
160 idxid in number,
161 part_id in number default null,
162 which in varchar2,
163 sep in varchar2 default DEFAULT_SEPARATOR
164 ) RETURN VARCHAR2;
165
166 /*-------------------------- get_object_name ------------------------------*/
167
168 FUNCTION get_object_name(
169 idx_owner in varchar2,
170 idx_name in varchar2,
171 idxid in number,
172 part_id in number default null,
173 which in varchar2,
174 sep in varchar2 default DEFAULT_SEPARATOR
175 ) RETURN VARCHAR2;
176
177 /*-------------------------- get_object_prefix ------------------------------*/
178
179 FUNCTION get_object_prefix(
180 idx_owner in varchar2,
181 idx_name in varchar2,
182 part_id in number default null,
183 sep in varchar2 default DEFAULT_SEPARATOR
184 ) RETURN VARCHAR2;
185
186 /*---------------------- swap_index_temp_tables -----------------------*/
187 PROCEDURE swap_index_temp_tables (
188 idx_owner in varchar2,
189 idx_name in varchar2,
190 idxid in number,
191 idx_pid in number,
192 temp_owner in varchar2,
193 temp_name in varchar2,
194 shadow_idxid in number default NULL,
195 shadow_ixpid in number default NULL
196 );
197
198 /*----------------------- populate_ptable -----------------------------------*/
199
200 PROCEDURE populate_ptable(
201 idx_owner in varchar2,
202 idx_name in varchar2,
203 idxid in number,
204 part_id in number default NULL,
205 shadow in boolean default FALSE,
206 ctxcat in boolean default FALSE
207 );
208
209 /*----------------------- AlterDollarITType --------------------------------*/
210
211 PROCEDURE AlterDollarITType(
212 idx in dr_def.idx_rec
213 );
214
215 PROCEDURE AdjustTType(
216 idx in dr_def.idx_rec,
217 shad_i in varchar2
218 );
219
220 FUNCTION get_create_sn_sql(
221 obj_name in varchar2,
222 x_part in boolean default FALSE
223 ) RETURN VARCHAR2;
224
225 FUNCTION get_create_snidx_sql(
226 base_obj_name in varchar2,
227 obj_name in varchar2,
228 x_part in boolean default FALSE
229 ) return varchar2;
230 end drvxtab;