oracle导入demp,oracle导入数据报错 急!

将备份的数据库文件导入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.

表空间扩展了再导还是不行,求高手指教!急!

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值