DBA Data[Home] [Help]

APPS.IBC_CONTENT_SYNC_INDEX_PKG dependencies on AD_CTX_DDL

Line 30: ad_ctx_ddl.sync_index( l_index_name );

26:
27: BEGIN
28:
29: IF bmode = 'S' THEN
30: ad_ctx_ddl.sync_index( l_index_name );
31: ELSIF bmode = 'OFAST' THEN
32: ad_ctx_ddl.optimize_index( l_index_name, CTX_DDL.OPTLEVEL_FAST, NULL, NULL );
33: ELSIF bmode = 'OFULL' THEN
34: ad_ctx_ddl.OPTIMIZE_INDEX( l_index_name, CTX_DDL.OPTLEVEL_FULL, NULL, NULL );

Line 32: ad_ctx_ddl.optimize_index( l_index_name, CTX_DDL.OPTLEVEL_FAST, NULL, NULL );

28:
29: IF bmode = 'S' THEN
30: ad_ctx_ddl.sync_index( l_index_name );
31: ELSIF bmode = 'OFAST' THEN
32: ad_ctx_ddl.optimize_index( l_index_name, CTX_DDL.OPTLEVEL_FAST, NULL, NULL );
33: ELSIF bmode = 'OFULL' THEN
34: ad_ctx_ddl.OPTIMIZE_INDEX( l_index_name, CTX_DDL.OPTLEVEL_FULL, NULL, NULL );
35: ELSIF bmode = 'R' THEN
36: EXECUTE IMMEDIATE 'alter index ' || l_index_name ||' REBUILD';

Line 34: ad_ctx_ddl.OPTIMIZE_INDEX( l_index_name, CTX_DDL.OPTLEVEL_FULL, NULL, NULL );

30: ad_ctx_ddl.sync_index( l_index_name );
31: ELSIF bmode = 'OFAST' THEN
32: ad_ctx_ddl.optimize_index( l_index_name, CTX_DDL.OPTLEVEL_FAST, NULL, NULL );
33: ELSIF bmode = 'OFULL' THEN
34: ad_ctx_ddl.OPTIMIZE_INDEX( l_index_name, CTX_DDL.OPTLEVEL_FULL, NULL, NULL );
35: ELSIF bmode = 'R' THEN
36: EXECUTE IMMEDIATE 'alter index ' || l_index_name ||' REBUILD';
37: ELSIF bmode = 'DR' THEN
38: -- logic to drop or create is taken in the individual api.