cancel
Showing results for 
Search instead for 
Did you mean: 

[Help] Shrink/Delete obsolete tablespace after SAP Upgrade

former_member229542
Active Participant
0 Kudos

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!

Accepted Solutions (1)

Accepted Solutions (1)

former_member188883
Active Contributor
0 Kudos

Hi Martin,

PSAPSR3701 its 99.4% free after being replaced by PSAPSRE702

Please check what are the tables under this tablespace PSAPSR3701. You can migrate those tables or objects to the new tablespace and the drop the tablespace PSAPSR3701.

Hope this helps.

Regards,

Deepak Kori

former_member229542
Active Participant
0 Kudos

Thanks Deepak

i followed your recommendation

Move tables from PSAPSR3701 to PSAPSR3701X

ACEVENTREPT

ACALERTREPT

Not sure if those tables are being used on SolMan 7.1. there are text tables for alerts and events

then alter index on the new tablespace

Drop old PSAPSR3701 which was taking up 24GB used space,then rename back PSAPSR3701x to PSAPSR3701 with only 1MB

Verified the tables on SE11 and they are active

Thanks

Answers (3)

Answers (3)

Reagan
Advisor
Advisor
0 Kudos

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

You need to move them from the old tablespace to the new tablespace after the upgrade.

brspace -c force -o process,time -u / -f tbreorg -a reorg -tablespace PSAPSR3701 -t "*" -parallel 3 -degree 3 -newts PSAPSRE702 -indts PSAPSRE702

After that you may drop the old tablespace.

Regards

RB

ashish_vikas
Active Contributor
0 Kudos

It will not allow you to do Resize datafile.

to release the free space from the tablespace, you should perform reorganization. Please check below link

http://scn.sap.com/thread/3304239

Thanks

ashish

paul_power
Active Contributor
0 Kudos

Hello Martin,

You could try option two which is to choose a resize value such that
only free space is in the trimmed region.

1. Resize the datafile using:

alter database datafile datafile_name resize <1 block smaller>;
If the resize fails with ORA-3297, it is also valid to resize the
datafile to 1 block larger:

alter database datafile datafile_name resize <1 block larger>;

2. Resize the datafile back to the original size.

Regards,

Paul

former_member229542
Active Participant
0 Kudos

Thanks Paul, but i couldnt use the alter resize statement

As Deepak mentioned, moved these two tables to a PSAPSR3701X Tablespace, dropped PSAPSR3701 and the rename back.

The tables involved on the move were

ACEVENTREPT

ACALERTREPT