Skip to Content
0
Former Member
Jul 20, 2009 at 05:12 AM

Large LOBSEGMENT

573 Views

Hello Experts,

We have a IDES system on Oracle 10G.

We had deleted two clients and reorg the database to get back some space. We managed to free some in PSAPSR3 table space but the reorg has increased the used space on SAPSR3700 by about 15Gb.

Further investigation i found that a couple of LOB segments have been created and they have taken up a large chunk of space. Not sure on what they do but is there any way i can reclaim this space.

Can these lob segments be dropped or deleted from the table space?

Regards

Anil Verma B