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:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.