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 出现的问题,请问如何解决?
请确认"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
是要修改DOMICILE字段吗?