Message-Id: <10665.120593@fatcity.com> From: "Koivu, Lisa" Date: Mon, 30 Oct 2000 14:41:48 -0500 Subject: RE: IMPORT ERRORS This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C042A9.71B03FFA Content-Type: text/plain; charset="iso-8859-1" Larry, change your initial/next extent to 100M or something. Check dba_free_space - you may not have a 426M contiguous extent available. Also, you can try coalescing your tablespace - you will see the results immediately in dba_Free_space. Multiple extents are not bad!! HTH Lisa Rutland Koivu Oracle Database Administrator Qode.com 4850 North State Road 7 Suite G104 Fort Lauderdale, FL 33319 V: 954.484.3191, x174 F: 954.484.2933 C: 954.658.5849 http://www.qode.com "The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com." -----Original Message----- From: Larry Taylor [mailto:ltaylor@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@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@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). ------_=_NextPart_001_01C042A9.71B03FFA Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: IMPORT ERRORS

Larry, change your initial/next extent to 100M or = something.  Check dba_free_space - you may not have a 426M = contiguous extent available.  Also, you can try coalescing your = tablespace - you will see the results immediately in = dba_Free_space. 

Multiple extents are not bad!! 

HTH

Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL  33319

V: 954.484.3191, x174
F: 954.484.2933
C: 954.658.5849
http://www.qode.com

"The information contained herein does not = express the opinion or position of Qode.com and cannot be attributed to = or made binding upon Qode.com."


-----Original Message-----
From: Larry Taylor [mailto:ltaylor@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@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@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 =