导入数据IMP-00058 ORA-00904
来源:互联网 发布:js utf16 编辑:程序博客网 时间:2024/06/05 03:42
将源库分区表数据迁移到历史库中碰到IMP-00058 ORA-00904错误,具体操作及解决如下:
$imp\'/ as sysdba\' STATISTICS=NONEDATA_ONLY=y file=/backup/wxlun20130911.dmplog=/backup/wxlun20130911.implog fromuser=wxlun touser=wxlun_his buffer=5400000
Import: Release 11.2.0.3.0 - Production on Wed Sep 11 10:54:392013
Copyright (c) 1982, 2011, Oracle and/or itsaffiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real ApplicationTesting options
Export file created by EXPORT:V11.02.00 via conventional path
Warning: the objects were exported by WXLUN, not by you
import done in ZHS16GBK character set and AL16UTF16 NCHAR characterset
. importing WXLUN's objects into WXLUN_HIS
. . importing partition "WXLUN_T01":"PT_201306"
IMP-00058: ORACLE error 904 encountered
ORA-00904: "TOEXPRESSCOMPANYID": invalid identifier
IMP-00057: Warning: Dump file may not contain data of allpartitions of this table
. . importing partition"WXLUN_T02":"VAPT_201306" 12553338 rows imported
IMP-00057: Warning: Dump file may not containdata of all partitions of this table---因为只导入一个分区数据,会报这个错误,在此忽略
Import terminated successfully with warnings.
表WXLUN_T02分区数据导入成功,而WXLUN_T01导入失败,查看目的库的WXLUN_T01表结构
SYS@wxlun_his>desc WXLUN.WXLUN_T01
Name Null? Type
------------------------------------------------- ----------------------------
BCID NOT NULL VARCHAR2(20)
FORMCODE NOT NULL VARCHAR2(50)
CURRENTSTATUS NOT NULL NUMBER(3)
PRESTATUS NOT NULL NUMBER(3)
RETURNSTATUS NUMBER(3)
OPERATETYPE
$imp
Import: Release 11.2.0.3.0 - Production on Wed Sep 11 10:54:392013
Copyright (c) 1982, 2011, Oracle and/or itsaffiliates.
Connected to: Oracle Database 11g Enterprise Edition Release11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real ApplicationTesting options
Export file created by EXPORT:V11.02.00 via conventional path
Warning: the objects were exported by WXLUN, not by you
import done in ZHS16GBK character set and AL16UTF16 NCHAR characterset
. importing WXLUN's objects into WXLUN_HIS
. . importing partition "WXLUN_T01":"PT_201306"
IMP-00058: ORACLE error 904 encountered
ORA-00904: "TOEXPRESSCOMPANYID": invalid identifier
IMP-00057: Warning: Dump file may not contain data of allpartitions of this table
. . importing partition
IMP-00057: Warning: Dump file may not containdata of all partitions of this table
Import terminated successfully with warnings.
表WXLUN_T02分区数据导入成功,而WXLUN_T01导入失败,查看目的库的WXLUN_T01表结构
SYS@wxlun_his>desc WXLUN.WXLUN_T01