Skip to Content
0
Dec 18, 2012 at 06:07 PM

Reorg SYS_LOB.........$$ table

319 Views

Hello all,

This is for PI/XI EHP2 on Oracle.

We have some very large LOB tables in our system and there name begins from SYS_LOB.....$$.

Is there any job to delete the entries from these table or just reorg them at Oracle level on regular basis. I read the note 500340 about this and it does not mention anything about this.

We ran already the following jobs to clean-up messages:

BXP-C-CPSXI-HOURLY-DELETE2

RSXMB_DELETE_MESSAGES

RSWF_XI_INSTANCES_DELETE

RSXMB_DELETE_HISTORY

RSWWWIDE

SAP_BC_XMB_DELETE_

SAP_BC_XMB_HIST_DELETE_

But no reduction in size

Please let me know if anybody has anyidea about this.

Thank you very to everybody in advance.