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