|
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。
|