Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RE: IMPORT ERRORS
Correction - it IS IGNORE=Y
> Lee Robertson
> Acxiom
> Tel: 0191 525 7344
> Fax: 0191 525 7007
> Email: lerobe_at_acxiom.co.uk
>
-----Original Message-----
From: Nagadevi Kavali [mailto:Nagadevik_at_coreobjects.com]
Sent: 31 October 2000 08: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!
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.
> 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 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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited.Received on Tue Oct 31 2000 - 04:52:29 CST
![]() |
![]() |