Database Utilities (MOSC)

MOSC Banner

ORA-28604 during impdp with network link option: table too fragmented to build bitmap index

edited May 26, 2015 10:00AM in Database Utilities (MOSC) 10 commentsAnswered

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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center