Reclaim space in tablespace
*** Oracle is currently working on an SR on this topic, while we are diagnosing the problem we are opening up this question to our user community so they can add perspective to the solution based on their real world experience ***
Problem : How to reclaim space in tablespace
Database: 10g
OS : Linux
Description :
We have EBS database and in order to reclaim
free space we did following:
1) alter table move to new tablespace TBLSPACEC2
2) Now old tablespace TBLSPACE contains long raw since "alter table" doesn't mve it.
In EBS we came to know that tablespace names should not be changed i.e. it should be TBLSPACE not TBLSPACE2 hence we need to move back TBLSPACE2 to TBLSPACE but before that want to recliam free space in TBLSPACE.
1) alter table move to new tablespace TBLSPACEC2
2) Now old tablespace TBLSPACE contains long raw since "alter table" doesn't mve it.
In EBS we came to know that tablespace names should not be changed i.e. it should be TBLSPACE not TBLSPACE2 hence we need to move back TBLSPACE2 to TBLSPACE but before that want to recliam free space in TBLSPACE.
0