Re: IMPORT ERRORS

Perhaps the storage is already used up?

Try this:

alter TABLESPACE IQ01IDX01 coalesce;

select bytes from dba_free_space where tablespace_name='IQ01IDX01' order by bytes desc;

Check to see if there is enough contiguous free space in the tablespace for all of your indexes.

• Original Message ----- From: Larry Taylor <ltaylor_at_iq.com> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Monday, October 30, 2000 1:24 PM 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 - 14:05:32 CST