Skip to Content
0
Oct 15, 2013 at 01:00 PM

[Help] Shrink/Delete obsolete tablespace after SAP Upgrade

306 Views

Hi guys, after upgrading Solution Manager from 7.0 to 7.1 there is an obsolete tablespace using a lot of assigned space

PSAPSR3701 its 99.4% free after being replaced by PSAPSRE702

Main issue here is need to get rid of this tablespace or at least decrease its size to minimum

Actual information of tablespace is the following

total tablespace size 23377920

free space 23376384

used space 0.01%

number of free extents 12


This tablespace takes up 4 datafiles, tried to resize them but the error message is

ORA-03297 file contains used data beyond requested RESIZE Value, but since its almost empty i couldnt understand why cannot be resized.

Should I drop this Tablespace or how can i reduce it size to minimum?

Any help welcome!