I know it has been said and recommended to use Locally Managed Tablespaces because of their space management and efficiency. However I find hard to believe the way Locally Managed Temporary Tablespace is behaving. NOT DEALLOCATING The free space after session is finished even not at shutdown.
I was on vacation and when I came back I realized that our LMTT has grown from 2G to 18G. The Jr. DBA just keep adding datafiles. and with LMTT there is no option to reclaim the free space.
Has any one experienced the same thing? I am thinking of using DMTT for both TEMPORARY AND RBS tablespace.
Please share your comment
[Edited by Ablakios on 10-18-2002 at 09:43 AM]
The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.