Line 98: ad_ctx_ddl.OPTIMIZE_INDEX(l_user_name||'.'||l_index_name,p_optimize_level,p_runtime);
94: -----------------------
95: OPEN c_index_name;
96: FETCH c_index_name INTO l_index_name;
97: IF c_index_name%FOUND THEN 98: ad_ctx_ddl.OPTIMIZE_INDEX(l_user_name||'.'||l_index_name,p_optimize_level,p_runtime); 99: END IF;
100: CLOSE c_index_name;
101:
102: /*
Line 175: ad_ctx_ddl.SYNC_INDEX(l_owner_name||'.'||l_index_name);
171: OPEN c_index_name;
172: FETCH c_index_name INTO l_index_name;
173: IF c_index_name%FOUND
174: THEN 175: ad_ctx_ddl.SYNC_INDEX(l_owner_name||'.'||l_index_name); 176: END IF;
177: CLOSE c_index_name;
178: /*
179: curs := dbms_sql.open_cursor;