14: g_excp_level number := FND_LOG.LEVEL_EXCEPTION;
15:
16: procedure sync is
17: begin
18: ad_ctx_ddl.set_effective_schema('okc');
19: ad_ctx_ddl.sync_index('okc_terms_templates_ctx');
20: exception
21: when others then raise;
22: end;
15:
16: procedure sync is
17: begin
18: ad_ctx_ddl.set_effective_schema('okc');
19: ad_ctx_ddl.sync_index('okc_terms_templates_ctx');
20: exception
21: when others then raise;
22: end;
23:
22: end;
23:
24: procedure optimize is
25: begin
26: ad_ctx_ddl.set_effective_schema('okc');
27: ad_ctx_ddl.optimize_index (
28: idx_name => 'okc_terms_templates_ctx',
29: optlevel => ad_ctx_ddl.optlevel_full,
30: maxtime => ad_ctx_ddl.maxtime_unlimited
23:
24: procedure optimize is
25: begin
26: ad_ctx_ddl.set_effective_schema('okc');
27: ad_ctx_ddl.optimize_index (
28: idx_name => 'okc_terms_templates_ctx',
29: optlevel => ad_ctx_ddl.optlevel_full,
30: maxtime => ad_ctx_ddl.maxtime_unlimited
31: );
25: begin
26: ad_ctx_ddl.set_effective_schema('okc');
27: ad_ctx_ddl.optimize_index (
28: idx_name => 'okc_terms_templates_ctx',
29: optlevel => ad_ctx_ddl.optlevel_full,
30: maxtime => ad_ctx_ddl.maxtime_unlimited
31: );
32: exception
33: when others then raise;
26: ad_ctx_ddl.set_effective_schema('okc');
27: ad_ctx_ddl.optimize_index (
28: idx_name => 'okc_terms_templates_ctx',
29: optlevel => ad_ctx_ddl.optlevel_full,
30: maxtime => ad_ctx_ddl.maxtime_unlimited
31: );
32: exception
33: when others then raise;
34: end;