ORA-28604 during impdp with network link option: table too fragmented to build bitmap index
Hello,
During cloning of production data with impdp method with network link option, process among others reported ORA-28604 table too fragmented to build bitmap index:
CREATE BITMAP INDEX."I_LOANS_OFFICER_CODE" ON Owner.TABLE ("OFFICER_CODE") PCTFREE 10 INITRANS 2 MAXTRANS 255 NOLOGGING STORAGE(INITIAL 2097152 NEXT 1048576 MINEXTENTS 1 M
AXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE TS_DATA PARALLEL 1
ORA-39083: Object type INDEX failed to create with error:
ORA-28604: table too fragmented to build bitmap index (218537341,24,24)
Have anybody of you confronted with this issue ?
How did you resolve it with any of work around?