How to Create Custom Oracle Function Based Indexes In Siebel Repository
(Doc ID 1562386.1)
Last updated on OCTOBER 14, 2023
Applies to:
Siebel CRM - Version 8.1.1.7 [21238] and laterInformation 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 |