Help, Here is the scenario. I am trying to import a schema (for days now) from a database on another machine to a new machine. I have created all the tablespaces, roles, users, etc. Some tables import ok others are getting an error.
ORA-01658: unable to create INITIAL extent for segment in tablespace MY_INDEX
IMP-00017: following statement failed with ORACLE error 1658:
"CREATE INDEX "S30_IX2" ON "S30" ("SP_FID" ) PCTFREE 5 INITRANS 2 MAXTRANS "
"255 STORAGE (INITIAL 409600 NEXT 102400 MINEXTENTS 1 MAXEXTENTS 500 PCTINCR"
"EASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SDE_I"
"NDEX" LOGGING"
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace MY_INDEX
. . importing table "S31" 7855 rows imported
IMP-00017: following statement failed with ORACLE error 1658:
"CREATE UNIQUE INDEX "S31_IX1" ON "S31" ("GX" , "GY" , "EMINX" , "EMINY" , ""
"EMAXX" , "EMAXY" , "SP_FID" ) PCTFREE 5 INITRANS 2 MAXTRANS 255 STORAGE (I"
"NITIAL 1024000 NEXT 102400 MINEXTENTS 1 MAXEXTENTS 500 PCTINCREASE 0 FREELI"
questions:
*** I am assumming that the import is trying to create an initial extent for index s30_IX2 of 409600,
and an initial extent for index s31_IX1 of 1024000. the old database had an initial extent of 20480. How did these extents get larger than 20480?
***same thing with the next extent was to be 40960 but both of these next extents are looking for 102400. How did they grow bigger than the original storage.
***Is this the reason why my import fails?
***What do you sugget I do, increasing the initial and next extent seems very high. Is this ok to do?
Reply With Quote
Bookmarks