RE: IMPORT ERRORS

You probably do not have enough contiguous free space to do the extent allocation.

Do SELECT MAX(bytes) FROM dba_freespace WHERE tablespace_name = 'IQ01IDX01';

Rick
> -----Original Message-----
> From: Larry Taylor [SMTP:ltaylor_at_iq.com]
> Sent: Monday, October 30, 2000 2:24 PM
> To: Multiple recipients of list ORACLE-L
> Subject: IMPORT ERRORS
>
> 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
>
> Thanks in advance...
> Lar
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Larry Taylor
> INET: ltaylor_at_iq.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Mon Oct 30 2000 - 13:52:18 CST