E-ORA: Index Builds on PT 8.55 are using incorrect DDL parameters
(Doc ID 2247555.1)
Last updated on JANUARY 03, 2023
Applies to:
PeopleSoft Enterprise PT PeopleTools - Version 8.55 and laterInformation in this document applies to any platform.
Goal
The create index script generated by Application Designer has the ALTER INDEX NOPARALLEL LOGGING clause.
Sample ALTER script
CREATE INDEX PS1PO_HDR ON PS_PO_HDR (PO_REF,
BUSINESS_UNIT,
PO_ID)
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 40960 NEXT 106496 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "PSINDEX"
/
ALTER INDEX PS1PO_HDR NOPARALLEL LOGGING
However, the DDL Model Defaults says PARALLEL NOLOGGING.
Sample DDL Model Defaults definition on AppDesigner and PIA
CREATE [UNIQUE] **BITMAP** INDEX [IDXNAME] ON [TBNAME] ([IDXCOLLIST])
TABLESPACE **INDEXSPC** STORAGE (INITIAL **INIT** NEXT **NEXT** MAXEXTENTS
**MAXEXT** PCTINCREASE **PCT**) PCTFREE **PCTFREE** PARALLEL NOLOGGING;
Why is this the case?
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 |