11g exp bug發現 = =||

今天使用以下指令備份時
exp \'/ as sysdba\' full=y file=full_exp.dmp log=full_exp.log recordlength=65535 direct=y buffer=512000000 rows=y statistics=none feedback=300000





. exporting materialized views
. exporting snapshot logs
EXP-00008: ORACLE error 1455 encountered
ORA-01455: converting column overflows integer datatype
EXP-00000: Export terminated unsuccessfully

查了一下

發現是11g(11.2.0.1) 的tratitional export 不支援snapshot log ,Bug 9306119 - Export fails with ORA-1455 when exporting snapshot logs [ID 9306119.8]
, 要升版到11.2.0.2才可解決

或改採data pump...

ref.
https://cn.forums.oracle.com/forums/thread.jspa?threadID=2240726