24小时热门版块排行榜

返回列表

当前主题已经存档。

Echizen

银虫 (小有名气)

应助: 0 (幼儿园)
金币: 373.8
帖子: 68
在线: 5.9小时
虫号: 231336
注册: 2006-03-27
专业: 计算机软件

[交流] 【求助】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

回复此楼