Delete or reset the queues sequentially & truncate the shareplex_trans table, as these data does not need to be replicated.
Set param SP_OCT_GEN_STOP 0x03 before upgrading Oracle to prevent capture from capturing the upgrade changes and preventing having to delete the queues. Once upgrade is done, reset param SP_OCT_GEN_STOP For example:
Before upgrading Oracle:
sp_ctrl> set param SP_OCT_GEN_STOP 0x03
Once you finish the upgrade reset param:
sp_ctrl> reset param SP_OCT_GEN_STOP
Upgraded Oracle from 8i to 10g.
Sample messages in export queue:
Sque 0, qseq 2612159777, NA, 18147/150413276, transid 25934, LOB data, AAAEYpAAAAAAAABAIW "WLI"."T_LBX_BIR_IMAGES", SCN