ORA-01658: unable to create INITIAL extent
hi,
I've exported my instance:
EXP SYSTEM/MANAGER@INSTANCE FULL=Y FILE=C:\EXP_FILE.DMP LOG=C:\ERROR_EXP.LOG
after I've created new tablespace and new user:
CREATE TABLESPACE MAX DATAFILE 'c:\MAX01.dbf' SIZE 3800M REUSE DEFAULT STORAGE
(INITIAL 10240 NEXT 10240 MINEXTENTS 1 MAXEXTENTS 256 PCTINCREASE 0) ONLINE;
CREATE USER MAX IDENTIFIED BY MAX DEFAULT TABLESPACE MAX TEMPORARY TABLESPACE TEMP;
finally I've imported tom's objects in MAX:
IMP SYSTEM/MANAGER@INSTANCE FROMUSER=TOM TOUSER=MAX FILE=C:\EXP_FILE.DMP LOG=C:\ERROR_IMP.log
but in some tables I get these errors:
IMP-00017: following statement failed with ORACLE error 1658:
"CREATE TABLE "AREA" ("OFL" VARCHAR2(4), "OBL" VARCHAR2(32), "OSITE" V"
"ARCHAR2(32), "OLS" VARCHAR2(32), "OAREA" NUMBER, "DV_ID" VARCHAR2(32), "DP_"
"ID" VARCHAR2(32), "ODISMESSO" VARCHAR2(2), "OTYPE" VARCHAR2(64), "OCAT" VAR"
"CHAR2(64), "OOCCUP" NUMBER, "SFL" VARCHAR2(32), "SBL" VARCHAR2(32), "SSITE""
" VARCHAR2(32), "PRORATE" VARCHAR2(8), "STYPE" VARCHAR2(64), "SCAT" VARCHAR2"
"(64), "SAREA" NUMBER, "SOCCUP" NUMBER, "AREA_SERV" NUMBER) PCTFREE 10 PCTU"
"SED 40 INITRANS 1 MAXTRANS 255 LOGGING STORAGE(INITIAL 314572800 NEXT 52428"
"800 MINEXTENTS 1 MAXEXTENTS 1000 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS "
"1 BUFFER_POOL DEFAULT) TABLESPACE "TOM""
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace TOM
I've increase tablespace TOM from 2.7Gb to 3.8Gb and after I've again FULL exported.
When I import again fromuser=tom touser=max...........
table AREA import correctly but I get same error on others tables:
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace TOM
IMP-00017: following statement failed with ORACLE error 1658:
"CREATE TABLE "Z_C" ("CLIENTE" VARCHAR2(50)) PCTFREE 10 PCTUSED 40 IN"
"ITRANS 1 MAXTRANS 255 LOGGING STORAGE(INITIAL 52428800 NEXT 52428800 MINEXT"
"ENTS 1 MAXEXTENTS 1000 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_P"
"OOL DEFAULT) TABLESPACE "TOM""
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace TOM IMP-00017: following statement failed with ORACLE error 1658:
"CREATE TABLE "Z_IG" ("RM_FOCA_PM" VARCHAR2(4) NOT NULL ENABLE, "DESCR" "
"VARCHAR2(80), "IMP_EL_MECC_ANTIN_ID" VARCHAR2(4), "IMP_ELEV_ID" VARCHAR2(4)"
", "TUT_AZ_ID" VARCHAR2(4), "OP_CIV_ID" VARCHAR2(4), "AREE_VERDI_ID" VARCHAR"
"2(4)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING STORAGE(INITIA"
"L 52428800 NEXT 52428800 MINEXTENTS 1 MAXEXTENTS 1000 PCTINCREASE 0 FREELIS"
"TS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "TOM""
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace TOM
Remember that Tablespace TOM is in another instance.
I exported the dmp from instance 'FIRE' and imported to instance 'LUKE' touser=MAX
Raf