| 查看: 843 | 回复: 2 | |||
| 当前主题已经存档。 | |||
[交流]
【求助】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 |
回复此楼» 猜你喜欢
售SCI-T0P文章，我:8O.5.5.1.O.54,科目齐全,可+急
已经有6人回复
-
售SCI一区文章，我:8.O.55.1.O.54,科目齐全,可伽急
已经有6人回复
-
有多少人是今天查系统知道结果的？
已经有18人回复
-
2026年叶企孙基金
已经有7人回复
-
我就是申请一个面上项目而已，这评审意见是按照杰青的条件评的吧？
已经有6人回复
-
售SCI一区文章，我:8.O.55.1.O.54,科目齐全,可伽急
已经有5人回复
-
售SCI文章，我:8O.5.5.1O.54,科目全,可十急
已经有4人回复
-
国自然评审意见
已经有15人回复
-
为什么资助数各大高校都创新高，自己申请怎么就这么难
已经有13人回复
-
国自然面上复盘~欢迎讨论
已经有14人回复
2楼2009-07-23 22:54:54
3楼2009-07-29 09:33:14
投票:
30