| 查看: 792 | 回复: 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 |
回复此楼» 猜你喜欢
化工专硕348，一志愿985求调剂
已经有6人回复
-
292求调剂
已经有3人回复
-
317一志愿华南理工电气工程求调剂
已经有3人回复
-
304求调剂
已经有4人回复
-
290求调剂
已经有6人回复
-
295求调剂
已经有5人回复
-
26申博
已经有4人回复
-
材料学调剂
已经有5人回复
-
264求调剂
已经有3人回复
-
311求调剂
已经有8人回复
3楼2009-07-29 09:33:14
2楼2009-07-23 22:54:54
