应《网络安全法》要求，自2017年10月1日起，未进行实名认证将不得使用互联网跟帖服务。为保障您的帐号能够正常使用，请尽快对帐号进行手机号验证，感谢您的理解与支持！

24小时热门版块排行榜    

小木虫论坛-学术科研互动平台 » 专业学科区 » 信息科学 » 程序算法 » 【求助】oracle 数据库导入出错怎么解决？
51/1返回列表
查看: 800  |  回复: 2
只看楼主 @他人 存档 新回复提醒 (忽略) 收藏    在APP中查看
当前主题已经存档。
当前只显示满足指定条件的回帖，点击这里查看本话题的所有回帖

Echizen

银虫 (小有名气)

[交流] 【求助】oracle 数据库导入出错怎么解决？

导入数据库的时候日记记录如下：导入失败。是什么问题呢？求助各位帮忙解决，谢谢。


Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
Export file created by EXPORT:V09.00.01 via conventional path
Warning: the objects were exported by SYSTEM, not by you
import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
IMP-00017: following statement failed with ORACLE error 29339:
"CREATE UNDO TABLESPACE "UNDOTBS" BLOCKSIZE 4096 DATAFILE  'D:\ORACLE\ORADAT"
"A\STAT\UNDOTBS01.DBF' SIZE 209715200       AUTOEXTEND ON NEXT 5242880  MAXS"
"IZE 16383M EXTENT MANAGEMENT LOCAL "
IMP-00003: ORACLE error 29339 encountered
ORA-29339: tablespace block size 4096 does not match configured block sizes
IMP-00017: following statement failed with ORACLE error 29339:
"CREATE TABLESPACE "CWMLITE" BLOCKSIZE 4096 DATAFILE  'D:\ORACLE\ORADATA\STA"
"T\CWMLITE01.DBF' SIZE 20971520       AUTOEXTEND ON NEXT 655360  MAXSIZE 163"
"83M EXTENT MANAGEMENT LOCAL  AUTOALLOCATE  ONLINE PERMANENT "
IMP-00003: ORACLE error 29339 encountered
ORA-29339: tablespace block size 4096 does not match configured block sizes
IMP-00017: following statement failed with ORACLE error 29339:
"CREATE TABLESPACE "DRSYS" BLOCKSIZE 4096 DATAFILE  'D:\ORACLE\ORADATA\STAT\"
"DRSYS01.DBF' SIZE 20971520       AUTOEXTEND ON NEXT 655360  MAXSIZE 16383M "
"EXTENT MANAGEMENT LOCAL  AUTOALLOCATE  ONLINE PERMANENT "
IMP-00003: ORACLE error 29339 encountered
ORA-29339: tablespace block size 4096 does not match configured block sizes
IMP-00017: following statement failed with ORACLE error 29339:
"CREATE TABLESPACE "EXAMPLE" BLOCKSIZE 4096 DATAFILE  'D:\ORACLE\ORADATA\STA"
"T\EXAMPLE01.DBF' SIZE 159907840       AUTOEXTEND ON NEXT 655360  MAXSIZE 16"
"383M EXTENT MANAGEMENT LOCAL  AUTOALLOCATE  ONLINE PERMANENT "
IMP-00003: ORACLE error 29339 encountered
ORA-29339: tablespace block size 4096 does not match configured block sizes
IMP-00017: following statement failed with ORACLE error 29339:
"CREATE TABLESPACE "INDX" BLOCKSIZE 4096 DATAFILE  'D:\ORACLE\ORADATA\STAT\I"
"NDX01.DBF' SIZE 26214400       AUTOEXTEND ON NEXT 1310720  MAXSIZE 16383M E"
"XTENT MANAGEMENT LOCAL  AUTOALLOCATE  ONLINE PERMANENT "
IMP-00003: ORACLE error 29339 encountered
ORA-29339: tablespace block size 4096 does not match configured block sizes
IMP-00017: following statement failed with ORACLE error 29339:
"CREATE TEMPORARY TABLESPACE "TEMP" BLOCKSIZE 4096 TEMPFILE  'D:\ORACLE\ORAD"
"ATA\STAT\TEMP01.DBF' SIZE 41943040       EXTENT MANAGEMENT LOCAL  UNIFORM S"
"IZE 1048576"
IMP-00003: ORACLE error 29339 encountered
ORA-29339: tablespace block size 4096 does not match configured block sizes
IMP-00017: following statement failed with ORACLE error 29339:
"CREATE TABLESPACE "TOOLS" BLOCKSIZE 4096 DATAFILE  'D:\ORACLE\ORADATA\STAT\"
"TOOLS01.DBF' SIZE 10485760       AUTOEXTEND ON NEXT 327680  MAXSIZE 16383M "
"EXTENT MANAGEMENT LOCAL  AUTOALLOCATE  ONLINE PERMANENT "
IMP-00003: ORACLE error 29339 encountered
ORA-29339: tablespace block size 4096 does not match configured block sizes
IMP-00017: following statement failed with ORACLE error 29339:
"CREATE TABLESPACE "USERS" BLOCKSIZE 4096 DATAFILE  'D:\ORACLE\ORADATA\STAT\"
"USERS01.DBF' SIZE 141557760       AUTOEXTEND ON NEXT 1310720  MAXSIZE 16383"
"M EXTENT MANAGEMENT LOCAL  AUTOALLOCATE  ONLINE PERMANENT "
IMP-00003: ORACLE error 29339 encountered
ORA-29339: tablespace block size 4096 does not match configured block sizes
IMP-00017: following statement failed with ORACLE error 959:
"CREATE USER "RMAN" IDENTIFIED BY VALUES 'E7B5D92911C831E1' DEFAULT TABLESPA"
"CE "TOOLS" TEMPORARY TABLESPACE "TEMP" PASSWORD EXPIRE ACCOUNT LOCK"
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'TOOLS' does not exist
IMP-00017: following statement failed with ORACLE error 990:
"GRANT CREATE SECURITY PROFILE TO "WKSYS""
IMP-00003: ORACLE error 990 encountered
ORA-00990: missing or invalid privilege
IMP-00017: following statement failed with ORACLE error 990:
"GRANT CREATE ANY SECURITY PROFILE TO "WKSYS""
IMP-00003: ORACLE error 990 encountered
ORA-00990: missing or invalid privilege
IMP-00017: following statement failed with ORACLE error 990:
"GRANT ALTER ANY SECURITY PROFILE TO "WKSYS""
IMP-00003: ORACLE error 990 encountered
ORA-00990: missing or invalid privilege
IMP-00017: following statement failed with ORACLE error 990:
"GRANT ADMINISTER SECURITY TO "WKSYS""
IMP-00003: ORACLE error 990 encountered
ORA-00990: missing or invalid privilege
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT UNLIMITED TABLESPACE TO "RMAN""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'RMAN' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "CONNECT" TO "RMAN""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'RMAN' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "RESOURCE" TO "RMAN""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'RMAN' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "RECOVERY_CATALOG_OWNER" TO "RMAN""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'RMAN' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "RMAN" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'RMAN' does not exist
IMP-00017: following statement failed with ORACLE error 959:
"ALTER USER "OLAPSYS" QUOTA UNLIMITED ON "CWMLITE""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'CWMLITE' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "RMAN" QUOTA UNLIMITED ON "TOOLS""
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'RMAN' does not exist
. importing AURORA$JIS$UTILITY$'s objects into AURORA$JIS$UTILITY$
. importing OSE$HTTP$ADMIN's objects into OSE$HTTP$ADMIN
. importing WKSYS's objects into WKSYS
. importing OLAPSYS's objects into OLAPSYS
. importing HR's objects into HR
. importing OE's objects into OE
. importing QS's objects into QS
. importing QS_WS's objects into QS_WS
. importing QS_ES's objects into QS_ES
. importing QS_OS's objects into QS_OS
. importing QS_CBADM's objects into QS_CBADM
. importing QS_CS's objects into QS_CS
. importing RMAN's objects into RMAN
"ALTER SESSION SET CURRENT_SCHEMA= "RMAN""
IMP-00003: ORACLE error 1435 encountered
ORA-01435: user does not exist
IMP-00000: Import terminated unsuccessfully
回复此楼

» 猜你喜欢
1楼 2009-07-23 17:10:41
已阅   回复此楼   关注TA 给TA发消息 送TA红花 TA的回帖

heraldic

木虫 (初入文坛)
★ ★
小木虫(金币+0.5):给个红包，谢谢回帖交流
bslt(金币+1,VIP+0):感谢交流，欢迎常来！ 7-29 19:06
用户 RMAN 不存在，你用 create user建一个吧，另外要给 connect,resource 的权限给它
赞一下(11人) 回复此楼
3楼2009-07-29 09:33:14
已阅   回复此楼   关注TA 给TA发消息 送TA红花 TA的回帖
查看全部 3 个回答

yikan1981

铁虫 (初入文坛)
★ ★
小木虫(金币+0.5):给个红包，谢谢回帖交流
bslt(金币+1,VIP+0):感谢交流。。。 7-25 19:41
oracle error 有专门的错误帮助，可以根据错误代码的提示找出错误的原因
赞一下(11人) 回复此楼
2楼2009-07-23 22:54:54
已阅   回复此楼   关注TA 给TA发消息 送TA红花 TA的回帖
查看全部 3 个回答
普通表情 龙 兔 虎 猫 高级回复 (可上传附件)
最具人气热帖推荐 [查看全部] 作者 回/看 最后发表
[考研] 086003食品工程求调剂 +3 淼淼111 2026-03-24 3/150 2026-03-24 09:47 by 云游重阳
[考研] 333求调剂 +3 ALULU4408 2026-03-23 3/150 2026-03-23 19:04 by macy2011
[考研] 上海电力大学材料防护与新材料重点实验室招收调剂研究生（材料、化学、电化学，环境） +3 我爱学电池 2026-03-23 3/150 2026-03-23 17:16 by AZMK
[论文投稿] 急发核心期刊论文 +3 贤达问津 2026-03-23 5/250 2026-03-23 17:13 by 妹子不好惹
[考研] 328求调剂 +4 LHHL66 2026-03-23 4/200 2026-03-23 14:55 by lbsjt
[考研] 一志愿东华大学化学070300，求调剂 +7 2117205181 2026-03-21 8/400 2026-03-22 22:55 by chixmc
[考研] 材料与化工085600，总分304，本科有两篇sci参与，求调剂 +4 幸运的酱酱 2026-03-22 5/250 2026-03-22 20:15 by edmund7
[考研] 275求调剂 +6 shansx 2026-03-22 8/400 2026-03-22 15:27 by barlinike
[考研] 求调剂 +5 Zhangbod 2026-03-21 7/350 2026-03-22 13:13 by Zhangbod
[考研] 303求调剂 +5 安忆灵 2026-03-22 6/300 2026-03-22 12:46 by 素颜倾城1988
[基金申请] 学校已经提交到NSFC，还能修改吗？ 40+4 babangida 2026-03-19 9/450 2026-03-21 16:12 by babangida
[考研] 求调剂 +3 白QF 2026-03-21 3/150 2026-03-21 13:12 by zhukairuo
[考研] 一志愿重庆大学085700资源与环境专硕，总分308求调剂 +3 墨墨漠 2026-03-18 3/150 2026-03-21 00:39 by JourneyLucky
[考研] 一志愿苏州大学材料求调剂，总分315（英一） +5 sbdksD 2026-03-19 5/250 2026-03-20 22:10 by luoyongfeng
[考研] A区线材料学调剂 +5 周周无极 2026-03-20 5/250 2026-03-20 21:33 by laoshidan
[考研] 0817 化学工程 299分求调剂 有科研经历 有二区文章 +22 rare12345 2026-03-18 22/1100 2026-03-20 20:39 by zhukairuo
[论文投稿] 申请回稿延期一个月，编辑同意了。但系统上的时间没变，给编辑又写邮件了，没回复 10+3 wangf9518 2026-03-17 4/200 2026-03-19 23:55 by babero
[考研] 085600材料与化工调剂 324分 +10 llllkkkhh 2026-03-18 12/600 2026-03-19 14:33 by llllkkkhh
[考研] 材料工程专硕调剂 +5 204818@lcx 2026-03-17 6/300 2026-03-18 22:55 by 204818@lcx
[考研] 考研求调剂 +3 橘颂. 2026-03-17 4/200 2026-03-17 21:43 by 有只狸奴
信息提示
关闭
请填处理意见
关闭