今天突然好多数据库再使用 exp备份的时候报错
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting user history table
EXP-00008: ORACLE error 1406 encountered
ORA-01406: fetched column value was truncated
EXP-00000: Export terminated unsuccessfully
求大神讲解,解决办法
我是在本机上导出备份的,不存在服务器和客户端不匹配的问题。
楼主有答案了吗?我也遇到了,查的结果是user_history$里有数据的情况下就报这个错,exp要读取这个表里的用户名,密码和创建时间。
fetched column value was truncated 预读的列被截断
https://www.cnblogs.com/gc001279/p/9140994.html
请贴具体 exp 命令。另外导出导入还是推荐数据泵(expdp/impdp)。