Issue with tablespaces APPS_TS_TX_DATA and APPS_TS_TX_IDX
Hi All,
We are trying to claim free space in couple of table-spaces, particularly APPS_TS_TX_DATA and APPS_TS_TX_IDX.
Currently 850 GB and 752 GB is allocated to these two table-spaces, respectively.
However only 330 GB and 300 GB is used, respectively, in each table-space.
We would like to get that free space back to the OS and we are thinking of the following approach, could you please let me know if you foresee any issues.
1) Create two new table-spaces (APPS_DATA with 11 data files of 32 GB each; APPS_IDX with 10 data files of 32 GB each)
2) Move tables and indexes (together) from the old table spaces to the new ones.
We are trying to claim free space in couple of table-spaces, particularly APPS_TS_TX_DATA and APPS_TS_TX_IDX.
Currently 850 GB and 752 GB is allocated to these two table-spaces, respectively.
However only 330 GB and 300 GB is used, respectively, in each table-space.
We would like to get that free space back to the OS and we are thinking of the following approach, could you please let me know if you foresee any issues.
1) Create two new table-spaces (APPS_DATA with 11 data files of 32 GB each; APPS_IDX with 10 data files of 32 GB each)
2) Move tables and indexes (together) from the old table spaces to the new ones.
Tagged:
0