I rewrote severl key functions in AUL to add the compress table support, but I found that the DMP format support is more robust in AUL 5. When I use the latest AUL 4 to unload table "SYS.IND$" as DMP format, the DMP file does not work, got the following error.
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.
When I unload it using AUL 5 Beta version, I get the correct result.
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.
Let's check the data with two MINUS operations.
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
I completely rewrote all the functions who process the block rows.