on 10-15-2013 2:00 PM
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!
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.