将备份的数据库文件导入oracle数据库报错,日志如下:
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
Export file created by EXPORT:V10.02.01 via conventional path
import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
. importing AIMS's objects into AIMS
. importing AIMS's objects into AIMS
. . importing table "RAW_DAY_E" 70747211 rows imported
IMP-00017: following statement failed with ORACLE error 1652:
"CREATE INDEX "IND_RAW_DAY_E_DATA_DT" ON "RAW_DAY_E" ("MP_ITEM_NO" , "DATA_D"
"T" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 4294967294 FREELIS"
"TS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "DAT_ARC" LOGGING"
IMP-00003: ORACLE error 1652 encountered
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP01
IMP-00017: following statement failed with ORACLE error 20000:
"BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"IND_RAW_DAY_E_DATA_DT"',NULL,NULL,"
"NULL,70791060,541181,70791060,1,1,70784086,3,6); END;"
IMP-00003: ORACLE error 20000 encountered
ORA-20000: INDEX "AIMS"."IND_RAW_DAY_E_DATA_DT" does not exist or insufficient privileges
ORA-06512: at "SYS.DBMS_STATS", line 2121
ORA-06512: at "SYS.DBMS_STATS", line 5393
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 1652:
"CREATE UNIQUE INDEX "PK_RAW_DAY_E" ON "RAW_DAY_E" ("MP_ITEM_NO" , "DI_ITEM_"
"NO" , "DATA_DT" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 42949"
"67294 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "DAT_AR"
"C" LOGGING"
IMP-00003: ORACLE error 1652 encountered
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP01
IMP-00017: following statement failed with ORACLE error 20000:
"BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"PK_RAW_DAY_E"',NULL,NULL,NULL,7198"
"9559,627627,71989559,1,1,71982144,3,6); END;"
IMP-00003: ORACLE error 20000 encountered
ORA-20000: INDEX "AIMS"."PK_RAW_DAY_E" does not exist or insufficient privileges
ORA-06512: at "SYS.DBMS_STATS", line 2121
ORA-06512: at "SYS.DBMS_STATS", line 5393
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 1652:
"ALTER TABLE "RAW_DAY_E" ADD CONSTRAINT "PK_RAW_DAY_E" PRIMARY KEY ("MP_ITE"
"M_NO", "DI_ITEM_NO", "DATA_DT") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS "
"255 STORAGE(INITIAL 4294967294 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DE"
"FAULT) TABLESPACE "DAT_ARC" LOGGING ENABLE "
IMP-00003: ORACLE error 1652 encountered
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP01
Import terminated successfully with warnings.
表空间扩展了再导还是不行,求高手指教!急!