Delete or reset the queues sequentially & truncate the shareplex_trans table, as these data does not need to be replicated.
NOTE:
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
sp_ctrl>start capture
sp_ctrl>stop capture
Once you finish the upgrade reset param:
sp_ctrl> reset param SP_OCT_GEN_STOP
sp_ctrl>start capture
sp_ctrl>stop capture
Additional Information:
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
3319185271610