345:
346: BEGIN
347:
348: IF bmode = 'S' THEN
349: AD_CTX_DDL.sync_index( l_index_name );
350: ELSIF bmode = 'OFAST' THEN
351: AD_CTX_DDL.OPTIMIZE_INDEX( l_index_name, CTX_DDL.OPTLEVEL_FAST, NULL, NULL );
352: ELSIF bmode = 'OFULL' THEN
353: AD_CTX_DDL.OPTIMIZE_INDEX( l_index_name, CTX_DDL.OPTLEVEL_FULL, NULL, NULL );
347:
348: IF bmode = 'S' THEN
349: AD_CTX_DDL.sync_index( l_index_name );
350: ELSIF bmode = 'OFAST' THEN
351: AD_CTX_DDL.OPTIMIZE_INDEX( l_index_name, CTX_DDL.OPTLEVEL_FAST, NULL, NULL );
352: ELSIF bmode = 'OFULL' THEN
353: AD_CTX_DDL.OPTIMIZE_INDEX( l_index_name, CTX_DDL.OPTLEVEL_FULL, NULL, NULL );
354: ELSIF bmode = 'R' THEN
355: -- 4321268: rebuild in parallel mode always. Serial online mode,
349: AD_CTX_DDL.sync_index( l_index_name );
350: ELSIF bmode = 'OFAST' THEN
351: AD_CTX_DDL.OPTIMIZE_INDEX( l_index_name, CTX_DDL.OPTLEVEL_FAST, NULL, NULL );
352: ELSIF bmode = 'OFULL' THEN
353: AD_CTX_DDL.OPTIMIZE_INDEX( l_index_name, CTX_DDL.OPTLEVEL_FULL, NULL, NULL );
354: ELSIF bmode = 'R' THEN
355: -- 4321268: rebuild in parallel mode always. Serial online mode,
356: -- is taking care in the individual index program.
357: IF pworker IS NOT NULL AND pworker > 0 THEN