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