|
-
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
Jovery, what tablespace I must take offline? 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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|