免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 1463 | 回复: 0
打印 上一主题 下一主题

问个问题 oracle9的数据导到10g的错误 [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2007-05-30 10:57 |只看该作者 |倒序浏览
[oracle@redhat bin]$ ./imp system/manager@juren file=/tools/sql/0530_10.dmp

Import: Release 10.2.0.1.0 - Production on 星期三 5月 30 10:34:14 2007

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

Export file created by EXPORT:V09.00.01 via conventional path
import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
IMP-00031: Must specify FULL=Y or provide FROMUSER/TOUSER or TABLES arguments
IMP-00000: Import terminated unsuccessfully

------------------------------------------------------------------------------------------------------------
如果加上 full=y 就会出现这样的问题
----------------------------------------------------------------------------------------------------------
IMP-00017: following statement failed with ORACLE error 29339:
"CREATE UNDO TABLESPACE "UNDOTBS" BLOCKSIZE 4096 DATAFILE  'D:\ORACLE\ORADAT"
"A\JUREN\UNDOTBS01.DBF' SIZE 209715200       AUTOEXTEND ON NEXT 5242880  MAX"
"SIZE 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\JUR"
"EN\CWMLITE01.DBF' SIZE 20971520       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 "DRSYS" BLOCKSIZE 4096 DATAFILE  'D:\ORACLE\ORADATA\JUREN"
"\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\JUR"
"EN\EXAMPLE01.DBF' SIZE 159907840       AUTOEXTEND ON NEXT 655360  MAXSIZE 1"
"6383M 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\JUREN\"
"INDX01.DBF' SIZE 26214400       AUTOEXTEND ON NEXT 1310720  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 TEMPORARY TABLESPACE "TEMP" BLOCKSIZE 4096 TEMPFILE  'D:\ORACLE\ORAD"
"ATA\JUREN\TEMP01.DBF' SIZE 41943040       EXTENT MANAGEMENT LOCAL  UNIFORM "
"SIZE 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\JUREN"
"\TOOLS01.DBF' SIZE 10485760       AUTOEXTEND ON NEXT 327680  MAXSIZE 16383M"
" EXTENT MANAGEMENT LOCAL  AUTOALLOCATE  ONLINE PERMANENT "
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP