Skip to Content
0
Former Member
Apr 18, 2014 at 04:19 AM

Reorg of Table with LOB Segment

2141 Views

Hello All,

We are planning to reorg the SXMSCLUP table in our PI SAP System.

System details are :

SAP Netweaver 7, SAP PI 7.0, Oracle 10G, Suse Linux

The table size is approx 61 GB with 5 GB index and Corresponding LOB Segment is around 400 GB.

I want to calculate the space required to reorg the tables. There is around 70 GB free space in Tablespce where the table SXMSCLUP belong.

Is it sufficient space to reorg the table.

I have also concern about LOBSEGMENT. Does Oracle also reorg/shrink the correspond LOB segment during the reorg of table.

If yes then which tablespace it use(e.g: PSAPTEMP), and how much approx space is needed.

Any help is appreciated.

Regards

Ashish