Should be ignore=y...:)
> -----Original Message-----
> From: EXT Nagadevi Kavali [mailto:Nagadevik_at_coreobjects.com]
> Sent: 31 October, 2000 10:50
> To: Multiple recipients of list ORACLE-L
> Subject: RE: RE: IMPORT ERRORS
>
>
>
> Correction..........
>
> If you want to create tables first and then import on top of
> it, you should
> give IMPORT=Y as one of your import parameter, which ignores
> any object
> creation errors.
>
> NRK.
>
> DBA/Database Architect
> CoreObjects
>
> -----Original Message-----
> Thankappan
> Sent: Tuesday, October 31, 2000 1:21 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi!
>
> sorry if I am 'too late'..
>
> But try exporting (in the 1st place!)
> with compress=N option explicitly set.
>
> This way it won't require a 'large' initial extent.
>
> Else create the table 'manually' and
> import with ignore=N
>
> Hope I've been useful!
>
> ------------- Original Message --------------
> Hamid Alavi <HamidA_at_aimdirect.co.nz> wrote:
> To:Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> From:Hamid Alavi <HamidA_at_aimdirect.co.nz>
> Date:Mon, 30 Oct 2000 13:00:55 -0800
> Subject:RE: IMPORT ERRORS
>
> Tom,
> This means your tablespace hasn't enough space check the data
> file for that
> tablespace or add another data file to that specific
> tablespace, hope it
> helps
>
> -----Original Message-----
> Sent: Tuesday, 31 October 2000 09:00
> To: Multiple recipients of list ORACLE-L
>
>
> 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 -----
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Sent: Monday, October 30, 2000 1:24 PM
>
>
> > 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).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Tom Pall
> INET: tom_at_cdproc.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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Hamid Alavi
> INET: HamidA_at_aimdirect.co.nz
>
> 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).
>
> _____________________________________________________
> Chat with your friends as soon as they come online. Get Rediff Bol at
> http://bol.rediff.com
>
> Participate in crazy auctions at http://auctions.rediff.com/auctions/
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Cyril Thankappan
> INET: cyril_thank_at_rediffmail.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).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Nagadevi Kavali
> INET: Nagadevik_at_coreobjects.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
Received on Tue Oct 31 2000 - 04:54:41 CST
