今天使用數(shù)據(jù)泵導(dǎo)入數(shù)據(jù)的時候報：ORA-02374: conversion error loading table "HR2QAS01"."V_PS_STAFFPOS_REPTO_PUB_MT"ORA-12899: value too large for column POST_NAME (actual: 57, maximum: 50)ORA-02372: data for row: POST_NAME : 0X'CBF3D6AFB2FAC6B7BFAAB7A2BCB0B9A9D3A6B9DCC0EDD7A8D2'發(fā)現(xiàn)原庫字符集（16GDK）和目標(biāo)數(shù)據(jù)庫字符集(UTF-8)不同。為了導(dǎo)入成功，我的解決辦法是：truncate table V_PS_STAFFPOS_REPTO_PUB_MT;alter table V_PS_STAFFPOS_REPTO_PUB_MT modify(POST_NAME VARCHAR2(60));然后再重新導(dǎo)入（只導(dǎo)入數(shù)據(jù));
