本周一应开发测试要求,搭建一套新的环境,我比较懒,就在原库上创建schema,心想搞搞算了,结果导入数据的时候报错:
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'
查看数据发现,字符集为AMERICAN_AMERICA.AL32UTF8,目前字符集AMERICAN_AMERICA.ZHS16GBK
没有找到其他解决办法,只好新建库了