问题描述
ORA-39346: data loss in character set conversion for object COMMENT"
对象COMMENT字符集转换丢失数据,导入失败不影响最终数据
,只影响表注释。
sqlplus xxxx/******** \
DIRECTORY=xxxx \
DUMPFILE=xxxx_%U.dmp \
REMAP_SCHEMA=xxxx:xxxx \
REMAP_TABLESPACE=xxxx:xxxx \
REMAP_TABLE=xxxx:xxxx \
TABLES=xxxx \
LOGFILE=xxxx.log \
TABLE_EXISTS_ACTION=REPLACE \
PARALLEL=4 \
INCLUDE=TABLE/TABLE,TABLE/TABLE_DATA,TABLE/COMMENT
原因分析:
expdp导出时COMMENT异常,导致导入对象COMMENT字符集转换丢失数据 INCLUDE=TABLE/TABLE,TABLE/TABLE_DATA,TABLE/COMMENT
解决方案:
导入时限制COMMENT
sqlplus xxxx/******** \
DIRECTORY=xxxx \
DUMPFILE=xxxx_%U.dmp \
REMAP_SCHEMA=xxxx:xxxx \
REMAP_TABLESPACE=xxxx:xxxx \
REMAP_TABLE=xxxx:xxxx \
TABLES=xxxx \
LOGFILE=xxxx.log \
TABLE_EXISTS_ACTION=REPLACE \
PARALLEL=4 \
INCLUDE=TABLE/TABLE,TABLE/TABLE_DATA