Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Failed to import bitmap indices

432553Nov 9 2004 — edited Nov 9 2004

Hi,

I'm running Oracle 10g on Red Hat Enterprise 3, using locally managed tablespaces with automatic segment space management.

I've some bitmap indices on a table that has 600 some columns (I know, I didn't design this table). I tried to export the schema and import the data into a new schema using expdp/impdp, and impdp failed to create these bitmap indices, the error log says:

ORA-28604: table too fragmented to build bitmap index (22046759,16,16)
Failing sql is:
CREATE BITMAP INDEX "SEERDMS"."XB_REC_SEX" ON "SEERDMS"."RECORD" ("SEX")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "SEER_IDX" PARALLEL 1

Can anyone help? I thought fragmentation is not supposed to be an issue when I'm using locally managed tablespace with automatic extent management.

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 7 2004

Added on Nov 9 2004

#general-database-discussions

6 comments

743 views