ORA-01401 inserted value too large for columnCause: The value entered is larger than the maximum width defined for the column.Action: Enter a value smaller than the column width or use the MODIFY option with ALTER TABLE to expand the column width.
可以查一下看看两个数据库的字符集是否相同;select * from sys.props$ a where a.name='NLS_CHARACTERSET'如果相同的话应该没问题的,如果不同不能导入导出的话, 可以考虑改字符集,但是,只有当新字符是当前字符的一个严谨的扩展集时才可以.比如US7ASCII是UTF8的子集 先关闭数据库, 然后启动并使系统禁止对话登陆: alter system enable restriced session alter system set job_queue_processes=0 alter database open; 修改字符集: alter database character set UTF8; 关闭数据库, 重起数据库.
ORA-01401 inserted value too large for columnCause: The value entered is larger than the maximum width defined for the column.Action: Enter a value smaller than the column width or use the MODIFY option with ALTER TABLE to expand the column width.
先关闭数据库,
然后启动并使系统禁止对话登陆:
alter system enable restriced session
alter system set job_queue_processes=0
alter database open;
修改字符集:
alter database character set UTF8;
关闭数据库,
重起数据库.