83:
84: -----------------------
85: -- rebuild the index --
86: -----------------------
87: curs := dbms_sql.open_cursor;
88: stmt := 'alter index '||owner||'.amv_c_channels_name_ctx rebuild online '||
89: 'parameters(''optimize '|| p_optimize_level || l_maxtime ||''')';
90: dbms_sql.parse(curs, stmt, dbms_sql.native);
91: rows := dbms_sql.execute(curs);
86: -----------------------
87: curs := dbms_sql.open_cursor;
88: stmt := 'alter index '||owner||'.amv_c_channels_name_ctx rebuild online '||
89: 'parameters(''optimize '|| p_optimize_level || l_maxtime ||''')';
90: dbms_sql.parse(curs, stmt, dbms_sql.native);
91: rows := dbms_sql.execute(curs);
92: dbms_sql.close_cursor(curs);
93:
94: curs := dbms_sql.open_cursor;
87: curs := dbms_sql.open_cursor;
88: stmt := 'alter index '||owner||'.amv_c_channels_name_ctx rebuild online '||
89: 'parameters(''optimize '|| p_optimize_level || l_maxtime ||''')';
90: dbms_sql.parse(curs, stmt, dbms_sql.native);
91: rows := dbms_sql.execute(curs);
92: dbms_sql.close_cursor(curs);
93:
94: curs := dbms_sql.open_cursor;
95: stmt := 'alter index '||owner||'.amv_c_channels_desc_ctx rebuild online '||
88: stmt := 'alter index '||owner||'.amv_c_channels_name_ctx rebuild online '||
89: 'parameters(''optimize '|| p_optimize_level || l_maxtime ||''')';
90: dbms_sql.parse(curs, stmt, dbms_sql.native);
91: rows := dbms_sql.execute(curs);
92: dbms_sql.close_cursor(curs);
93:
94: curs := dbms_sql.open_cursor;
95: stmt := 'alter index '||owner||'.amv_c_channels_desc_ctx rebuild online '||
96: 'parameters(''optimize '|| p_optimize_level || l_maxtime ||''')';
90: dbms_sql.parse(curs, stmt, dbms_sql.native);
91: rows := dbms_sql.execute(curs);
92: dbms_sql.close_cursor(curs);
93:
94: curs := dbms_sql.open_cursor;
95: stmt := 'alter index '||owner||'.amv_c_channels_desc_ctx rebuild online '||
96: 'parameters(''optimize '|| p_optimize_level || l_maxtime ||''')';
97: dbms_sql.parse(curs, stmt, dbms_sql.native);
98: rows := dbms_sql.execute(curs);
93:
94: curs := dbms_sql.open_cursor;
95: stmt := 'alter index '||owner||'.amv_c_channels_desc_ctx rebuild online '||
96: 'parameters(''optimize '|| p_optimize_level || l_maxtime ||''')';
97: dbms_sql.parse(curs, stmt, dbms_sql.native);
98: rows := dbms_sql.execute(curs);
99: dbms_sql.close_cursor(curs);
100:
101: --
94: curs := dbms_sql.open_cursor;
95: stmt := 'alter index '||owner||'.amv_c_channels_desc_ctx rebuild online '||
96: 'parameters(''optimize '|| p_optimize_level || l_maxtime ||''')';
97: dbms_sql.parse(curs, stmt, dbms_sql.native);
98: rows := dbms_sql.execute(curs);
99: dbms_sql.close_cursor(curs);
100:
101: --
102: EXCEPTION
95: stmt := 'alter index '||owner||'.amv_c_channels_desc_ctx rebuild online '||
96: 'parameters(''optimize '|| p_optimize_level || l_maxtime ||''')';
97: dbms_sql.parse(curs, stmt, dbms_sql.native);
98: rows := dbms_sql.execute(curs);
99: dbms_sql.close_cursor(curs);
100:
101: --
102: EXCEPTION
103: WHEN OTHERS THEN
143:
144: -----------------------
145: -- rebuild the index --
146: -----------------------
147: curs := dbms_sql.open_cursor;
148: stmt := 'alter index '||owner||'.amv_c_channels_name_ctx rebuild online '||
149: 'parameters(''sync'')';
150: dbms_sql.parse(curs, stmt, dbms_sql.native);
151: rows := dbms_sql.execute(curs);
146: -----------------------
147: curs := dbms_sql.open_cursor;
148: stmt := 'alter index '||owner||'.amv_c_channels_name_ctx rebuild online '||
149: 'parameters(''sync'')';
150: dbms_sql.parse(curs, stmt, dbms_sql.native);
151: rows := dbms_sql.execute(curs);
152: dbms_sql.close_cursor(curs);
153:
154: curs := dbms_sql.open_cursor;
147: curs := dbms_sql.open_cursor;
148: stmt := 'alter index '||owner||'.amv_c_channels_name_ctx rebuild online '||
149: 'parameters(''sync'')';
150: dbms_sql.parse(curs, stmt, dbms_sql.native);
151: rows := dbms_sql.execute(curs);
152: dbms_sql.close_cursor(curs);
153:
154: curs := dbms_sql.open_cursor;
155: stmt := 'alter index '||owner||'.amv_c_channels_desc_ctx rebuild online '||
148: stmt := 'alter index '||owner||'.amv_c_channels_name_ctx rebuild online '||
149: 'parameters(''sync'')';
150: dbms_sql.parse(curs, stmt, dbms_sql.native);
151: rows := dbms_sql.execute(curs);
152: dbms_sql.close_cursor(curs);
153:
154: curs := dbms_sql.open_cursor;
155: stmt := 'alter index '||owner||'.amv_c_channels_desc_ctx rebuild online '||
156: 'parameters(''sync'')';
150: dbms_sql.parse(curs, stmt, dbms_sql.native);
151: rows := dbms_sql.execute(curs);
152: dbms_sql.close_cursor(curs);
153:
154: curs := dbms_sql.open_cursor;
155: stmt := 'alter index '||owner||'.amv_c_channels_desc_ctx rebuild online '||
156: 'parameters(''sync'')';
157: dbms_sql.parse(curs, stmt, dbms_sql.native);
158: rows := dbms_sql.execute(curs);
153:
154: curs := dbms_sql.open_cursor;
155: stmt := 'alter index '||owner||'.amv_c_channels_desc_ctx rebuild online '||
156: 'parameters(''sync'')';
157: dbms_sql.parse(curs, stmt, dbms_sql.native);
158: rows := dbms_sql.execute(curs);
159: dbms_sql.close_cursor(curs);
160:
161: --
154: curs := dbms_sql.open_cursor;
155: stmt := 'alter index '||owner||'.amv_c_channels_desc_ctx rebuild online '||
156: 'parameters(''sync'')';
157: dbms_sql.parse(curs, stmt, dbms_sql.native);
158: rows := dbms_sql.execute(curs);
159: dbms_sql.close_cursor(curs);
160:
161: --
162: EXCEPTION
155: stmt := 'alter index '||owner||'.amv_c_channels_desc_ctx rebuild online '||
156: 'parameters(''sync'')';
157: dbms_sql.parse(curs, stmt, dbms_sql.native);
158: rows := dbms_sql.execute(curs);
159: dbms_sql.close_cursor(curs);
160:
161: --
162: EXCEPTION
163: WHEN OTHERS THEN