Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from snowy0 on Sep 16 at 10:26 AM Hi,
Google will help you. Keywords to use:
oracle 9i shrink tablespace size
| | | ---------------Original Message---------------
From: rayudu2006
Sent: Thursday, September 15, 2016 9:52 AM
Subject: Unable To Gain Space From OS Level After Reorg, Even After Performing Table Reorg Unable To Gain Space From OS Level
Hello Experts,
We are running SAP application (R/3 4.6C) with Oracle 9.2.0.5.
OS version AIX - 5.3
We are out of space to add in OS level for data files so we have selected few tables like "SOC3, SOST, SOOD, SOES, SOCS, SOFM, SOOS, NAST,APQD, TST03 and TBTCP" and deleted huge unusable data expecting to reorg them and gain space in OS level.
We used tool "SAPDBA" to perform reorg on those tables and finished successfully. (BRTOOLS not available to perform reorg)
While performing the reorg we received few errors like below:
Missing space in Tablespace PSAPBTABD
for 2 not fitting extents:
So, we added datafiles in different directories (Locally mounted) and proceeded with reorg activity expecting to reduce the size of the newly added datafiles and move to sapdata directories (As in Oracle 9.2 we don't have an option to delete datafile so we are able to resize the datafiles but not all the files we added. May be data os spread even to those newly added datafiles) sad.gif sad.gif
Though after reorg, the size of the tables decreased and the Allocated space decreased. However, we are unable to reduce the space of all the datafiles we added. Please find below screenshot of Tablespace (Before and After the activity):
Before the Reorg Activity:
TABLESPACE Total Allocated %-Alloc. Files Free areas Largest
-----------------
PSAPBTABD 139929440 128579240 92 90 611 1425904
After the Reorg Activity:
TABLESPACE Total Allocated %-Alloc. Files Free areas Largest
----------------
PSAPBTABD 155658144 117793184 76 109 856 665600
I couldn't find an easy option with this DB version to perform reorg of tablespace and datafiles to gain space.
Could someone please help me how can we gain space in OS level?
Thanks,
Subbu |
| Reply to this email to post your response. __.____._ | In the Spotlight Become a blogger at Toolbox.com and share your expertise with the community. Start today.    _.____.__ |
