Skip to Content
0
Former Member
Jan 27, 2011 at 10:57 AM

Index

42 Views

Hi,

Can you please help on this issue?

Our system is SAP ECC6 on oracle database 10g. we are plannng to reorg for the bigger indexes size which it is more

than temp tablespace size.

Current temp tablespace size 28GB and reorg indexe size is 80GB. For this we will increasing the temp tablespace size

to more than 80 GB and after reorg we will reduce the size to 36 GB.

During reducing the temp tspace size from 80GB to 36GB is there any impact on the system. If temp datafile is corrupted during reducing the size, can you please help what is the procedure to recover

Any parameter that we can set or increase in SAP so that it will use memory before using the temp tablespace.

Thanks

BBM