DBA Data[Home] [Help]

APPS.CS_KB_CONC_PROG_PKG dependencies on CTX_DDL

Line 349: AD_CTX_DDL.sync_index( l_index_name );

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 );

Line 351: AD_CTX_DDL.OPTIMIZE_INDEX( l_index_name, CTX_DDL.OPTLEVEL_FAST, 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,

Line 353: AD_CTX_DDL.OPTIMIZE_INDEX( l_index_name, CTX_DDL.OPTLEVEL_FULL, NULL, NULL );

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