Messages in export queue after Oracle upgrade (24102)

Export queue with messages after Oracle upgrade. This is a reverse config for HA purposes

Capture capture changes done by the Oracle user to replicated objects by the Oracle upgrade

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