oracle数据同步失败返回1,导入数据库时ORA-01400错误 - Oracle数据库管理 - Oracle数据库数据恢复、性能优化来问问AskMaclean - ParnassusData诗檀...

本帖最后由 chunchun2012 于 2012-12-9 20:24 编辑

从源数据库中运行

select CARD_SPEC from MISDB.OPT_STD_OPERATION_CARD;

发现有如下输出内容

CARD_SPEC

----------

3002

(。。。正常显示的数值)

SP2-0784: Invalid or incomplete character beginning 0xC1 returned

4002

SP2-0784: Invalid or incomplete character beginning 0xC2 returned

SP2-0784: Invalid or incomplete character beginning 0xC2 returned

SP2-0784: Invalid or incomplete character beginning 0xC1 returned

SP2-0784: Invalid or incomplete character beginning 0xC1 returned

SP2-0784: Invalid or incomplete character beginning 0xC1 returned

。。。(正常显示的数值)

但输出结果中没有NULL值。

是否是因为其中部分”Invalid or incomplete character“导致导入错误?

===============================

导出命令为：

exp misdb/ht@hb file=d:\dbbackup\db.dmp log=d:\dbbackup\db.log owner=(misdb,cmms_annex) compress=y direct=n rows=y consistent=n constraints=y grants=y indexes=y triggers=y

=================================

导入的过程为：

[oracle@testWIS ~]$ imp misdb/ht

Import: Release 10.2.0.1.0 - Production on Thu Dec 6 04:53:11 2012

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

Import file: expdat.dmp > /u0/db.dmp

Enter insert buffer size (minimum is 8192) 30720>

Export file created by EXPORT:V10.02.01 via conventional path

import done in US7ASCII character set and AL16UTF16 NCHAR character set

import server uses ZHS16GBK character set (possible charset conversion)

export client uses ZHS16GBK character set (possible charset conversion)

export server uses UTF8 NCHAR character set (possible ncharset conversion)

List contents of import file only (yes/no): no >

Ignore create error due to object existence (yes/no): no >

Import grants (yes/no): yes >

Import table data (yes/no): yes >

Import entire export file (yes/no): no > yes

. importing MISDB's objects into MISDB

. importing CMMS_ANNEX's objects into CMMS_ANNEX

. importing MISDB's objects into MISDB

. . importing table                 "ADD_MATERIAL"         25 rows imported

.....

IMP-00019: row rejected due to ORACLE error 1400

IMP-00003: ORACLE error 1400 encountered

ORA-01400: cannot insert NULL into ("MISDB"."OPT_STD_OPERATION_CARD"."CARD_SPEC")