IMPORT ERRORS

From: Larry Taylor <ltaylor_at_iq.com>
Date: Mon, 30 Oct 2000 11:18:55 -0800
Message-Id: <10665.120588@fatcity.com>

Hi all,

I'm performing an import into a 8.1.6 database and got the following errors. I added a 1 gig datafile to TABLESPACE IQ01IDX01, but still got the same errors.

Does anyone have a suggestion?

IMP-00003: ORACLE error 1658 encountered ORA-01658: unable to create INITIAL extent for segment in tablespace IQ01IDX01
IMP-00017: following statement failed with ORACLE error 1658:
"CREATE UNIQUE INDEX "PK_FDFAF_C_ID" ON "DW_FLOW_ACTION_FACT" ("C_ID" )
PCT"
"FREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 447651840 NEXT 223715328
MI"
"NEXTENTS 1 MAXEXTENTS 505 PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1
BUFF"
"ER_POOL DEFAULT) TABLESPACE "IQ01IDX01" LOGGING"
IMP-00003: ORACLE error 1658 encountered ORA-01658: unable to create INITIAL extent for segment in tablespace IQ01IDX01
IMP-00017: following statement failed with ORACLE error 1658:
"ALTER TABLE "DW_FLOW_ACTION_FACT" ADD CONSTRAINT "PK_FDFAF_C_ID" PRIMARY
K"
"EY ("C_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL
"
"447651840 NEXT 223715328 MINEXTENTS 1 MAXEXTENTS 505 PCTINCREASE 50
FREELIS"
"TS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "IQ01IDX01" ENABLE
"
IMP-00003: ORACLE error 1658 encountered ORA-01658: unable to create INITIAL extent for segment in tablespace IQ01IDX01 Received on Mon Oct 30 2000 - 13:18:55 CST