oracle导入数库错误02374，26093，02372请求帮助

Question

Import: Release 11.2.0.1.0 - Production on Sat Nov 12 21:50:08 2022

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options
Master table "TBCLOU"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "TBCLOU"."SYS_IMPORT_FULL_01": username/* directory=DATA_DIR dumpfile=tcy_01.dmp,tcy_02.dmp full=y
ORA-02374: conversion error loading table "TBCLOU"."TB_6232"
ORA-26093: input data column size (193) exceeds the maximum input size (22)
ORA-02372: data for row: DOMICILE : ''

Job "TBCLOU"."SYS_IMPORT_FULL_01" stopped due to fatal error at 22:50:17

oracle数据导入运行 impdp username/123456 directory=DATA_DIR dumpfile=tcy_01.dmp,tcy_02.dmp full=y 出现的问题，请问如何解决？

Answer 1

请确认"TBCLOU"."TB_6232"在目标库是否存在，不存在则是目标数据库与源数据库字符集不一致，比如源zhs16gbk,目标为utf8。
如果存在，修改字段长度到194；表不在，创建表，字段长度加大大194，再imdpd选择只导入数据可以解决。
impdp username/123456 directory=DATA_DIR dumpfile=tcy_01.dmp,tcy_02.dmp tables='TBCLOU.TB_6232' content=data_only