Have a large number of indexes to build. And I am trying leverage parallel.

My system has 8 cpus. It is on Oracle 19c Red Hat 9.4

This an example of the sql which I created with impdb include=constraints sqlfile=xxx

I am only show to partitions but there are hundreds more.

I have tried "alter session force parallel DDL; The table is set to parallel 8.

Any help would be appreciated as this is taking days.

ALTER TABLE "DWSUPWHSL"."TR_DTN_ALLOC" ADD CONSTRAINT "TR_DTN_ALLOC_PK" PRIMARY KEY ("EFFECTIVE_DT", "TERMINAL_KEY", "CONSIGNEE_KEY", "PRODUCT_KEY", "PRODUCT_ALLOC_KEY", "PRODUCT_ALLOC_ACTIVE")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)