exp的客户端是10gr2,服务器端是18cr2
脚本导出的内容:
exp $u/$u@$db file=files/${u}_Q_PROG.dmp log=logs/${u}_Q_PROG.log tables=Q_%
执行后错误如下:
Export: Release 10.2.0.1.0 - Production on Tue Jun 28 03:05:57 2022
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Export done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set
EXP-00008: ORACLE error 1455 encountered
ORA-01455: converting column overflows integer datatype
EXP-00000: Export terminated unsuccessfully
google后的解决方法:http://www.dba-oracle.com/t_exp_00008_oracle_error_1455_encountered.htm
增加这三个参数:constraints=n indexes=n statistics=none
脚本改成:
exp $u/$u@$db file=files/${u}_Q_PROG.dmp log=logs/${u}_Q_PROG.log constraints=n indexes=n statistics=none
不过注意最后需要将索引同步到target database。