My Oracle Support Banner

How to Create Custom Oracle Function Based Indexes In Siebel Repository (Doc ID 1562386.1)

Last updated on NOVEMBER 13, 2018

Applies to:

Siebel CRM - Version 8.1.1.7 [21238] and later
Information in this document applies to any platform.
Reviewed for relevance "2-SEP-2016".

Goal

Can we create Function Based Indexes in Siebel Repository? Will it cause any issues ? There are few custom Function Based Indexes
Is it fine to add them in the repository and not to add them after every repository migration to production?


**************
CREATE INDEX SIEBEL.C360_S_SRV_REQ_01_X ON SIEBEL.S_SRV_REQ

(TRUNC("CREATED"))

LOGGING

TABLESPACE SIEBEL_DEF_INDEX

PCTFREE 10

INITRANS 2

MAXTRANS 255

STORAGE (

  INITIAL 128M

  NEXT 128M

  MINEXTENTS 1

  MAXEXTENTS UNLIMITED

  PCTINCREASE 0

  BUFFER_POOL DEFAULT

  FLASH_CACHE DEFAULT

  CELL_FLASH_CACHE DEFAULT

  )

PARALLEL ( DEGREE 8 INSTANCES 1 );


Can this index definition now be included as part of the Siebel 8 repository?
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.