oracle imp 3113,求助imp出现的3113,3114问题

本帖最后由 silencehill_wu 于 2011-11-3 23:59 编辑

import数据进数据库发生错误

下面是命令

imp userid=tmsdevt02/tmsdevt02@ORCL full=y file="Q:\数据库\tmsdb\tmsDB.dmp"  ignore=y tablespaces=TMSDEEV

出现了3113，3114错误问题，下面就是错误的结果

Q:\> imp userid=tmsdevt02/tmsdevt02@ORCL full=y file="Q:\数据库\tmsdb\tmsDB.dmp"  ignore=y tablespaces=TMSDEEV

Import: Release 9.2.0.4.0 - Production on 星期四 11月 3 23:35:14 2011

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

连接到: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production

With the Partitioning, OLAP and Oracle Data Mining options

JServer Release 9.2.0.4.0 - Production

经由常规路径导出由EXPORT:V09.02.00创建的文件

已经完成ZHS16GBK字符集和AL16UTF16 NCHAR 字符集中的导入

. 正在将SYSTEM的对象导入到 SYSTEM

IMP-00017: 由于 ORACLE 的 3113 错误，以下的语句失败

"BEGIN  "

"SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_EVALUATIO"

"N_CONTEXT_OBJ, 'SYS',TRUE);"

""

"SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_EVALUATIO"

"N_CONTEXT_OBJ, 'DBA',TRUE);"

""

"SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_EVALUATIO"

"N_CONTEXT_OBJ, 'AQ_ADMINISTRATOR_ROLE',TRUE);"

""

"SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_EVALUATIO"

"N_CONTEXT_OBJ, 'MDSYS',TRUE);"

""

"SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_EVALUATIO"

"N_CONTEXT_OBJ, 'CTXSYS',FALSE);"

""

"SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_EVALUATIO"

"N_CONTEXT_OBJ, 'WKSYS',FALSE);"

""

"SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_ANY_EVALU"

"ATION_CONTEXT, 'SYS',TRUE);"

""

"SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_ANY_EVALU"

"ATION_CONTEXT, 'DBA',TRUE);"

""

"SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_ANY_EVALU"

"ATION_CONTEXT, 'MDSYS',TRUE);"

""

"SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_ANY_EVALU"

"ATION_CONTEXT, 'CTXSYS',FALSE);"

""

"SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_ANY_EVALU"

"ATION_CONTEXT, 'WKSYS',FALSE);"

""

"SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.ALTER_ANY_EVALUA"

"TION_CONTEXT, 'SYS',TRUE);"

""

"SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.ALTER_ANY_EVALUA"

"TION_CONTEXT, 'DBA',TRUE);"

""

"SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.ALTER_ANY_EVALUA"

"TION_CONTEXT, 'MDSYS',TRUE);"

""

"SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.ALTER_ANY_EVALUA"

"TION_CONTEXT, 'CTXSYS',FALSE);"

""

"SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.ALTER_ANY_EVALUA"

"TION_CONTEXT, 'WKSYS',FALSE);"

""

"SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.DROP_ANY_EVALUAT"

"ION_CONTEXT, 'SYS',TRUE);"

""

"SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.DROP_ANY_EVALUAT"

"ION_CONTEXT, 'DBA',TRUE);"

""

"SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.DROP_ANY_EVALUAT"

"ION_CONTEXT, 'MDSYS',TRUE);"

""

"SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.DROP_ANY_EVALUAT"

"ION_CONTEXT, 'CTXSYS',FALSE);"

""

"SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.DROP_ANY_EVALUAT"

"ION_CONTEXT, 'WKSYS',FALSE);"

""

"SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.EXECUTE_ANY_EVAL"

"UATION_CONTEXT, 'SYS',TRUE);"

""

"SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.EXECUTE_ANY_EVAL"

"UATION_CONTEXT, 'DBA',TRUE);"

""

"SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.EXECUTE_ANY_EVAL"

"UATION_CONTEXT, 'MDSYS',TRUE);"

""

"SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.EXECUTE_ANY_EVAL"

"UATION_CONTEXT, 'CTXSYS',FALSE);"

""

"SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.EXECUTE_ANY_EVAL"

"UATION_CONTEXT, 'WKSYS',FALSE);"

""

"COMMIT; END;"

IMP-00003: 遇到 ORACLE 错误 3113

ORA-03113: 通信通道的文件结束

IMP-00003: 遇到 ORACLE 错误 3114

ORA-03114: 未连接到 ORALCE

然后去看alert_sid.log文件，发现下面的ORA-1543 错误信息

Thu Nov 03 23:35:14 2011

CREATE TABLESPACE "EXAMPLE" BLOCKSIZE 8192 DATAFILE  'D:\ORACLE\ORADATA\TMS\EXAMPLE01.DBF' SIZE 156631040       AUTOEXTEND ON NEXT 655360  MAXSIZE 32767M EXTENT MANAGEMENT LOCAL  AUTOALLOCATE  ONLINE PERMANENT  NOLOGGING SEGMENT SPACE MANAGEMENT AUTO

ORA-1543 signalled during: CREATE TABLESPACE "EXAMPLE" BLOCKSIZE 8192 DATAFIL...

Thu Nov 03 23:35:14 2011

CREATE TABLESPACE "INDX" BLOCKSIZE 8192 DATAFILE  'D:\ORACLE\ORADATA\TMS\INDX01.DBF' SIZE 26214400       AUTOEXTEND ON NEXT 1310720  MAXSIZE 32767M EXTENT MANAGEMENT LOCAL  AUTOALLOCATE  ONLINE PERMANENT  NOLOGGING SEGMENT SPACE MANAGEMENT AUTO

ORA-1543 signalled during: CREATE TABLESPACE "INDX" BLOCKSIZE 8192 DATAFILE  ...

Thu Nov 03 23:35:14 2011

CREATE TABLESPACE "ODM" BLOCKSIZE 8192 DATAFILE  'D:\ORACLE\ORADATA\TMS\ODM01.DBF' SIZE 20971520       AUTOEXTEND ON NEXT 655360  MAXSIZE 32767M EXTENT MANAGEMENT LOCAL  AUTOALLOCATE  ONLINE PERMANENT  NOLOGGING SEGMENT SPACE MANAGEMENT AUTO

ORA-1543 signalled during: CREATE TABLESPACE "ODM" BLOCKSIZE 8192 DATAFILE  '...

Thu Nov 03 23:35:14 2011

CREATE TABLESPACE "TOOLS" BLOCKSIZE 8192 DATAFILE  'D:\ORACLE\ORADATA\TMS\TOOLS01.DBF' SIZE 10485760       AUTOEXTEND ON NEXT 327680  MAXSIZE 32767M EXTENT MANAGEMENT LOCAL  AUTOALLOCATE  ONLINE PERMANENT  NOLOGGING SEGMENT SPACE MANAGEMENT AUTO

ORA-1543 signalled during: CREATE TABLESPACE "TOOLS" BLOCKSIZE 8192 DATAFILE ...

Thu Nov 03 23:35:14 2011

CREATE TABLESPACE "USERS" BLOCKSIZE 8192 DATAFILE  'D:\ORACLE\ORADATA\TMS\USERS01.DBF' SIZE 1182       AUTOEXTEND ON NEXT 1310720  MAXSIZE 32767M EXTENT MANAGEMENT LOCAL  AUTOALLOCATE  ONLINE PERMANENT  NOLOGGING SEGMENT SPACE MANAGEMENT AUTO

ORA-1543 signalled during: CREATE TABLESPACE "USERS" BLOCKSIZE 8192 DATAFILE ...

Thu Nov 03 23:35:14 2011

CREATE TABLESPACE "XDB" BLOCKSIZE 8192 DATAFILE  'D:\ORACLE\ORADATA\TMS\XDB01.DBF' SIZE 39976960       AUTOEXTEND ON NEXT 655360  MAXSIZE 32767M EXTENT MANAGEMENT LOCAL  AUTOALLOCATE  ONLINE PERMANENT  NOLOGGING SEGMENT SPACE MANAGEMENT AUTO

ORA-1543 signalled during: CREATE TABLESPACE "XDB" BLOCKSIZE 8192 DATAFILE  '...

Thu Nov 03 23:35:14 2011

CREATE TABLESPACE "TMSDEV" BLOCKSIZE 8192 DATAFILE  'D:\ORACLE\ORADATA\TMS\TMSDEV.ORA' SIZE 10000       EXTENT MANAGEMENT LOCAL  AUTOALLOCATE  ONLINE PERMANENT  NOLOGGING SEGMENT SPACE MANAGEMENT AUTO

ORA-1543 signalled during: CREATE TABLESPACE "TMSDEV" BLOCKSIZE 8192 DATAFILE...

当前的数据库是oracle 9.0.2, os是xp

实际上我只需要创建一个TMSDEV就可以了，为什么会创建上面几乎所有的db中的tablespace，这到底是怎么回事，是不是exp 的时候就有问题？

第一次碰到这种情况，查了半天没有结果，请教高手帮忙。谢谢！！

最好全面系统的解释一下，以便能够看得明白。