【ORACLE】报错IMP-00058ORA-00942

最新推荐文章于 2023-06-26 11:57:15 发布

AskTOMmorow

最新推荐文章于 2023-06-26 11:57:15 发布

阅读量1.3k

点赞数

分类专栏： ORACLE troubleshoot 文章标签： oracle

本文链接：https://blog.csdn.net/AskTommorow/article/details/59110368

版权

【原因】检查了一下导出的日志，发现了问题：
一、dmp文件是由10.02.01导出的
二、目标库的版本是10.2.0.1.0
三、导入dmp用的客户端是11.2.0.1.0
估计是版本的问题导致，我直接到目标数据的服务器导数据，导入一切正常。

为什么有些表能正常导入，有些表有问题呢？检查的结果是，所有不能正常导入的表中都含有CLOB字段。

--Error log

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

经由直接路径由 EXPORT:V10.02.01 创建的导出文件
已经完成 ZHS16GBK 字符集和 AL16UTF16 NCHAR 字符集中的导入
IMP-00017: 由于 ORACLE 错误 2304, 以下语句失败:
 "CREATE TYPE "TID" TIMESTAMP '2009-05-26:16:50:39' OID '6ACCFBA89B29A0A6E043"
 "AC13647AA0A6'   IS OBJECT(TID VARCHAR2(30));"
 ""
IMP-00003: 遇到 ORACLE 错误 2304
ORA-02304: 无效的对象标识符文字
IMP-00017: 由于 ORACLE 错误 2304, 以下语句失败:
 "CREATE TYPE "TIDS" TIMESTAMP '2009-05-26:16:51:06' OID '6ACCFBA89B2DA0A6E04"
 "3AC13647AA0A6'   IS TABLE OF TID;"
 ""
IMP-00003: 遇到 ORACLE 错误 2304
ORA-02304: 无效的对象标识符文字
IMP-00017: 由于 ORACLE 错误 2304, 以下语句失败:
 "CREATE TYPE "TTAB" TIMESTAMP '2009-06-15:09:52:55' OID '6C597A8C03443088E04"
 "3AC13647A3088'   IS OBJECT(F_1 VARCHAR2(300),"
 "                                      F_2 VARCHAR2(300),"
 "                                      F_3 VARCHAR2(300),"
 "                                      F_4 VARCHAR2(300),"
 "                                      F_5 VARCHAR2(300))"
IMP-00003: 遇到 ORACLE 错误 2304
ORA-02304: 无效的对象标识符文字
IMP-00017: 由于 ORACLE 错误 2304, 以下语句失败:
 "CREATE TYPE "TTABS" TIMESTAMP '2009-06-15:09:53:26' OID '6C597A8C034C3088E0"
 "43AC13647A3088'   IS TABLE OF TTAB"
IMP-00003: 遇到 ORACLE 错误 2304
ORA-02304: 无效的对象标识符文字
IMP-00017: 由于 ORACLE 错误 2304, 以下语句失败:
 "CREATE TYPE "QUEST_SOO_ARCHIVE_DEST_TYP" TIMESTAMP '2010-11-22:12:53:49' OI"
 "D '959E0AB84D6CD03EE043AC136479D03E'   IS OBJECT ("
 "    SEQUENCE_NUM                              NUMBER(12,0),"
 "    DEST_NAME                                 VARCHAR2(50),"
 "    STATUS                                    VARCHAR2(50),"
 "    TARGET                                    VARCHAR2(50),"
 "    DESTINATION                               VARCHAR2(256),"
 "    DESTINATION_END                           VARCHAR2(256),"
 "    BINDING                                   VARCHAR2(50),"
 "    LOG_SEQUENCE                              NUMBER(12,0),"
 "    REOPEN_SECS                               NUMBER(12,0),"
 "    TRANSMIT_MODE                             VARCHAR2(50),"
 "    TYPE                                      VARCHAR2(50),"
 "    VALID_TYPE                                VARCHAR2(50),"
 "    TOTAL_MB                                  NUMBER(14,2),"
 "    FREE_MB                                   NUMBER(14,2),"
 "    USABLE_FILE_MB                            NUMBER(14,2),"
 "    IS_ASM                                    VARCHAR2(10),"
 "    IS_RECOVERY                               VARCHAR2(10),"
 "    MIN_RECORD                                NUMBER(1,0),"
 "    TIME_TO_FAILURE                           NUMBER,"
 "    INSTANCE_NAME                             VARCHAR2(64),"
 "    LOCAL_TTF                                 NUMBER,"
 "    LOCAL_MIN_REC                             NUMBER(