AnySQL.net

    为了加上压缩(Compress)表的支持, 完全重写了几个处理块内记录的重要函数, 没想到改完后测试, 发现对DMP格式恢复支持的更好了. 用最新的AUL 4去将"SYS.IND$"恢复成DMP文件, 在导入时发现这个DMP文件不能使用, 遇到了以下错误.

import done in UTF8 character set and AL16UTF16 NCHAR character set
export client uses US7ASCII character set (possible charset conversion)
. importing MYDUL's objects into SH2
. . importing table                         "IND$"
IMP-00020: long column too large for column buffer size (22)
IMP-00028: partial import of previous table rolled back: 1100 rows rolled back
Import terminated successfully with warnings.

    而我用AUL 5测试版本时, 导入就完全没有问题.

import done in UTF8 character set and AL16UTF16 NCHAR character set
export client uses US7ASCII character set (possible charset conversion)
. importing MYDUL's objects into SH2
. . importing table                         "IND$"       1176 rows imported
Import terminated successfully without warnings.

    在SQL*Plus中用两个Minus操作去检验一下恢复出来的结果.

SQL> show user
USER is "SYS"
SQL> select * from ind$ minus select * from sh2.ind$;

no rows selected

SQL> select * from sh2.ind$ minus select * from ind$;

no rows selected

    可以看到恢复的结果完全准确, 这真是意外的收获, 热列推荐使用AUL 5来进行恢复.